Oracle 序列的創建和使用

創建序列 create sequence seq_a minvalue 1000 maxvalue 99999999 start with 1000 increment by 1 nocache; 查詢序列 select seq_a.nextval from dual; drop sequence seq_a 為每張表生成對應的序列 --創建存儲過程 create or replace procedure p_createseq(tablename in varchar2) is strsql varchar2(500); begin strsql:='create sequence seq_'||tablename||' minvalue 1000 maxvalue 99999999 start with 1000 increment by 1 nocache'; execute immediate strsql; end p_createseq; / --創建序列 exec p_createseq('t_power'); exec p_createseq('t_roler'); exec p_createseq('t_roler_power'); exec p_createseq('t_department'); exec p_createseq('t_quarters'); exec p_createseq('t_quarters_roler'); exec p_createseq('t_emp'); exec p_createseq('t_require_plan'); exec p_createseq('t_require_minutia'); exec p_createseq('t_require_audit'); exec p_createseq('t_engage'); exec p_createseq('t_home'); exec p_createseq('t_education'); exec p_createseq('t_works'); exec p_createseq('t_skill'); exec p_createseq('t_account'); exec p_createseq('t_licence'); exec p_createseq('t_title'); exec p_createseq('t_remove'); exec p_createseq('t_train'); exec p_createseq('t_pact'); exec p_createseq('t_assess'); exec p_createseq('t_attendance'); exec p_createseq('t_reward_punish'); exec p_createseq('t_dimission'); exec p_createseq('t_emp_roler'); exec p_createseq('t_code');

轉載于:https://blog.51cto.com/gghhgame51333/41210

總結

以上是生活随笔為你收集整理的Oracle 序列的创建和使用的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。