兼容 Oracle sequence

​ 序列在UDB-TX Oracle兼容版本中用于生成唯一的数字序列,常用于自增ID等场景

用例

unvdb=# CREATE sequence udb_ora_sql;
CREATE SEQUENCE
unvdb=# SELECT udb_ora_sql.NEXTVAL FROM DUAL;
 nextval
---------
       1
(1 row)
unvdb=# ALTER sequence udb_ora_sql restart start with 10;
ALTER SEQUENCE
unvdb=# SELECT udb_ora_sql.NEXTVAL FROM DUAL;
 nextval
---------
       10
(1 row)
unvdb=# DROP SEQUENCE udb_ora_sql;
DROP SEQUENCE