Re: INSERT INTO on AFTER UPDATE trigger
> I want to insert a record into the row_change table
> for each field that changed in the trigger field:
You mean the requirement is to insert a row_change row for every `field` column where the NEW column value differs from the OLD? That'll require a block like ...
if new.col1 <> old col1 then
insert into row_change ...
end if;
... for each `field` column.
Subject
Views
Written By
Posted
1314
June 26, 2020 06:21AM
630
June 26, 2020 06:28AM
Re: INSERT INTO on AFTER UPDATE trigger
622
June 26, 2020 09:16AM
565
June 26, 2020 02:41PM
574
June 26, 2020 02:46PM
692
June 26, 2020 02:49PM
536
June 26, 2020 02:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.