oracle序列课题

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

??