Re: Pre update trigger query ..
From: godmann <allanwtham_at_yahoo.com>
Date: 9 Sep 2001 21:05:42 -0700
Message-ID: <95cd51c.0109092005.32ead1cd_at_posting.google.com>
create or replace trigger updateemp2
before update on scott.emp
for each row
begin
if :old.job <> :new.job then
dbms_output.put_line('They are not the same'); insert into emp2 values ('Hi there'); end if;
end;
/
Date: 9 Sep 2001 21:05:42 -0700
Message-ID: <95cd51c.0109092005.32ead1cd_at_posting.google.com>
Hi there,
Try the following code: Create first a table called emp2(remark varchar2(20)) and try to update job for emp.
create or replace trigger updateemp2
before update on scott.emp
for each row
begin
if :old.job <> :new.job then
dbms_output.put_line('They are not the same'); insert into emp2 values ('Hi there'); end if;
end;
/
Allan W. Tham
DBA
Received on Mon Sep 10 2001 - 06:05:42 CEST