创建sequence序列
创建名字为wip_keys_s序列,其中从1开始增加,每次增加1
SQL> create sequence wip_keys_s
2 minvalue 1
3 start with 1
4 increment by 1
5 order
6 ;
Sequence created
通过序列获取值
SQL> select wip.wip_keys_s.nextval from dual;
NEXTVAL
----------
1