Oracle-序列、索引和同義字____Oracle

序列

--create sequencecreate sequence empseqincrement by 10start with 10maxvalue 100cycle--need cyclenocache--needn't cache--查詢序列select sequence_name,min_value,max_value,increment_by,last_number from user_sequences--尋找下一個值select empseq.nextval from dual--尋找當前值select empseq.currval from dual--修改序列[不能更改啟動序號]alter sequence empseqincrement by 1nocyclenocache--刪除序列--使用序列作為主鍵向表中插入值insert into emp01values(empseq.nextval,'AA',5500)

索引和同義字

--建立索引create index emp01_id_ixon emp01(employee_id)--刪除索引drop index emp01_id_ix;--建立同義字；create synonym e for employeesselect * from e--刪除同義字drop synonym e;