Oracle创建序列是我们最常用的操作之一，下面就为您详细介绍Oracle创建序列及查询序列的语法知识，希望对您能够有所帮助。
Oracle创建序列
- create sequence seq_a minvalue 1000 maxvalue 99999999 start with 1000 increment by 1 nocache;
查询序列
- select seq_a.nextval from dual;
为每张表生成对应的序列
--创建存储过程
- 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;
- /
--Oracle创建序列
- 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');
【编辑推荐】
