View Single Post
  #3  
Old February 14th, 2004, 11:56 AM
Napolean Napolean is online now
Senior eCharchan
 
Join Date: Jul 2001
Posts: 8,981
Napolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond reputeNapolean has a reputation beyond repute
Quote:
Originally posted by Pappu Pager
If you want to examine the new value inserted in the table A then use :new.colname instead of selecting the inserted value from the table

Example

create or replace trigger nepali
after insert on table A
for each row
begin
if :new.colname:='something' then
update B set col2='anything' where col1=:new.colname;
end if;
end;
Thanks very much Pappu......
But you look familiar man..... reply to my PM...
Reply With Quote