oracle序列专题

查看当前用户所有序列:

select * from user_sequences; 

 

创建序列

create sequence SEQ_TBLCLASSROOM 
start with 50 
increment by 10 
MAXvalue 1E27 
cache 10; 

 
修改序列

alter sequence SEQ_TBLCLASSROOM 
  maxvalue 200 cache 20 ; 

 

删除序列

drop sequence  tigger_TBLCLASSROOM; 

 

使用序列 

nextVal:用于返回下一个序列号 
Curral:用于返回当前序列号 

insert into TBLCLASSROOM(id ,name) values(SEQ_TBLCLASSROOM.Nextval,'gouchao');