pl/sql如何更改序列的名字ALTER SEQUENCE x_kja_test_trigger_seq RENAME TO xx_kja_test_trigger_seq这
pl/sql如何更改序列的名字
ALTER SEQUENCE x_kja_test_trigger_seq RENAME TO xx_kja_test_trigger_seq;
这样报错,我苦恼中!
[解决办法]
- SQL code
--使用下面的方法试试RENAME x_kja_test_trigger_seq TO xx_kja_test_trigger_seq;
[解决办法]
实测
- SQL code
--创建序列CREATE SEQUENCE MySequenceSTART WITH 10 INCREMENT BY -1MINVALUE 1 MAXVALUE 10CYCLE CACHE 5;
