dssd

asdasd
mail@pastecode.io avatar
unknown
plain_text
2 years ago
764 B
2
Indexable
Never
--3

CREATE INDEX prac_nazwa_ind ON PRACOWNICY(first_name, last_name);

--6

CREATE UNIQUE INDEX prac_premia ON PRACOWNICY (commission_pct);

--7

CREATE INDEX prac_data_zat ON PRACOWNICY(hire_date);

SELECT hire_date FROM PRACOWNICY WHERE hire_date IS NOT NULL;

--8

CREATE INDEX prac_upper_nazwisko_id ON PRACOWNICY(UPPER(last_name));

INSERT INTO PRACOWNICY(first_name, last_name) VALUES('Nowy', 'Pracownik');

--9

CREATE UNIQUE INDEX prac_stan ON PRACOWNICY (job_id);

--14

ALTER INDEX prac_nazwa_ind

RENAME TO prac_imie_nazw_ind;

--15

DROP INDEX prac_imie_ind;

--16

SELECT all_indexes.index_name FROM ALL_INDEXES WHERE index_name LIKE 'PRAC%';

DROP INDEX(SELECT * FROM ALL_INDEXES WHERE index_name LIKE 'PRAC%');