--创建序列 create sequence sqe1 start with 1 increment by 1 maxvalue 9999999 nocycle --用触发器实现自动插入自增的列(这里id 为你的自增列) create or replace tigger tri_tb before insert on tb for each row declare v_id tb.id%type; begin select sqe1.nextval into v_id from dual; :new.id:=v_id; end;
create sequen sqe1 start with 1 increment by 1insert into tb(sqe1.nextval,.....)--也可以用触发器create or replace trigger p_incre before insert on tb for each row declare v_id tb.id%type; begin select sqe1.nextval into v_id from dual; :new.id:=v_id; end;
定义触发器之后,sql语句插入数据时直接把这个字段空着就行,相当于有一个默认值
能过sequence 来实现处增. 创建sequence create sequence autoinc minvalue 1 start with 1 increment by 1 nocycle cache 10; 使用 insert into table_name values (autoinc.nextval,........)
其中使用:
:new.id:=id_seq.next_val; --id_seq为序列名称。
create sequence sqe1
start with 1
increment by 1
maxvalue 9999999
nocycle
--用触发器实现自动插入自增的列(这里id 为你的自增列)
create or replace tigger tri_tb before insert on tb for each row
declare
v_id tb.id%type;
begin
select sqe1.nextval into v_id from dual;
:new.id:=v_id;
end;
create sequen sqe1
start with 1
increment by 1insert into tb(sqe1.nextval,.....)--也可以用触发器create or replace trigger p_incre before insert on tb for each row
declare
v_id tb.id%type;
begin
select sqe1.nextval into v_id from dual;
:new.id:=v_id;
end;
创建sequence
create sequence autoinc
minvalue 1
start with 1
increment by 1
nocycle
cache 10;
使用
insert into table_name values (autoinc.nextval,........)