-
Hi
just want to write a simple before delete/on delete trigger that inserts the row in another table when the row is delete from one table
create or replace trigger RF_TEST_SHIPTO
before delete on SHIPTO
for each row
begin
if :old.STSTAT <>'P'
THEN
insert into TEST_SHIPTO select * from shipto;
end if;
end ;
/
Please let me know the syntax and I am getting a mutation everytime I run this one
regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|