create or replace trigger trg_insert_dept
before insert on dept
for each row
declare
-- local variables here
begin
if INSERTING then
insert into dept(dept_id) select TYPE_ID.nextval from dual;
end if;
end trg_insert_dept;
before insert on dept
for each row
declare
-- local variables here
begin
if INSERTING then
insert into dept(dept_id) select TYPE_ID.nextval from dual;
end if;
end trg_insert_dept;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货