创建序列:
CREATE sequence 序列名
minvalue 1
maxvalue 9999999999999999999999999999
start with 2
increment by 2
cache 20
order;
引用:
ALTER TABLE 表名
MODIFY ("ID" DEFAULT "序列名".nextval );
删除序列:
drop sequence 序列名;
创建序列:
CREATE sequence 序列名
minvalue 1
maxvalue 9999999999999999999999999999
start with 2
increment by 2
cache 20
order;
引用:
ALTER TABLE 表名
MODIFY ("ID" DEFAULT "序列名".nextval );
删除序列:
drop sequence 序列名;