--11g
create or replace trigger tr_name
before insert on table_name
for each row
begin
:new.id := seq_name.nextval;
end;
/
create or replace trigger tr_name
before insert on table_name
for each row
begin
:new.id := seq_name.nextval;
end;
/
--10g
create or replace trigger tr_name
before insert on table_name
for each row
declare
v_id number;
begin
select seq_name.nextval into v_id from dual;
:new.id := v_id;
end;
/
before insert on table_name
for each row
declare
v_id number;
begin
select seq_name.nextval into v_id from dual;
:new.id := v_id;
end;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13177610/viewspace-689058/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
mysql查看表大小
请登录后发表评论
登录
全部评论
