建了两张同样的表testtrigger和testtrigger1,里面有三列,PID number,PNAME varchar2(10),PSEX char(1)然后建立触发器。。想插第一张表的时候也插入第二张表。删除的时候也一样。
create or replace trigger biufer_mytest1
before insert or update
of PNAME
on testtrigger
for each row
begin
if inserting
then
insert into TestTrigger1 values(new_value.PID,new_value.PNAME,new_value.PSEX);
elsif deleting
then
delete from TestTrigger1 where PID = old_value.PID;
end if;
end;
报错new_value那一行:列在此处不允许
old_value那一行,标识符无效为啥啊?new_value和old_value到底该怎么用呢??谢谢了嘿嘿
create or replace trigger biufer_mytest1
before insert or update
of PNAME
on testtrigger
for each row
begin
if inserting
then
insert into TestTrigger1 values(new_value.PID,new_value.PNAME,new_value.PSEX);
elsif deleting
then
delete from TestTrigger1 where PID = old_value.PID;
end if;
end;
报错new_value那一行:列在此处不允许
old_value那一行,标识符无效为啥啊?new_value和old_value到底该怎么用呢??谢谢了嘿嘿
偶来班门弄斧下,哈哈引用时应该这样写:
:new.PID
new,old 是相对谁的呢?
呵呵。