序列:(预分配的一组内存空间)
用序列作为序列主键
创建:
SQL> create sequence s2 start with 1 increment by 1 maxvalue 5 nocache nocycle;
应用:
SQL> insert into t1 values(s2.nextval);
序列:(预分配的一组内存空间)
用序列作为序列主键
创建:
SQL> create sequence s2 start with 1 increment by 1 maxvalue 5 nocache nocycle;
应用:
SQL> insert into t1 values(s2.nextval);