查看当前用户所有序列:

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'); 

??