1:创建系列,用于创建唯一记录
create sequence abc
increment by 1
start with 10
maxvalue 9999
nocycle nocache;
删除系列
drop sequence abc;
使用系列:
select abc.nextval from 工作人员;
select abc.currval from 工作人员;
查看系列:
select sequence_name,min_value,max_value,increment_by,last_number from user_sequences;
create sequence abc
increment by 1
start with 10
maxvalue 9999
nocycle nocache;
删除系列
drop sequence abc;
使用系列:
select abc.nextval from 工作人员;
select abc.currval from 工作人员;
查看系列:
select sequence_name,min_value,max_value,increment_by,last_number from user_sequences;