oracle-sequences, indexes, and synonyms ____oracle

Sequence

--create sequence

Create sequence empseq
increment by the
start
with MaxValue Cycle
Nocache--needn ' t cache


--query sequence
Select Sequence_name,min_value,max_value,increment_by,last_ Number from 
user_sequences-


-Find Next value
Select Empseq.nextval from dual-
-Find current value
Select Empseq.currval from dual

--Modify sequence [cannot change boot serial number]
alter sequence EMPSEQ
increment by 1
nocycle
NoCache--

Delete sequence-

-Inserts a value into the table using a sequence as a primary key insert into
emp01
values (empseq.nextval, ' AA ', 5500)

Indexes and synonyms

--Create INDEX
Emp01_id_ix on
emp01 (employee_id)-


-delete index
drop indices emp01_id_ix;

--Create
synonym E for employees

select * FROM e

--delete synonym
drop synonym e;