If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I am building an audit table that only has a single data column to record changes taking place in the user tables. Most of changes will be updating a single column in user tables.
I am using a trigger type of (for each row), but that leads me to a problem with updating multiple columns at one time on the user's tables. If the trigger only fires once for an update, is there any way to create multiple rows (one for each column in user table) inside of the trigger. I can't see how my current format of trigger could be adjusted that way. Example of current trigger below.

CREATE OR REPLACE
TRIGGER "EIIS_TEST"."SHIP_SETTING_TRIGGER"
AFTER INSERT OR DELETE OR UPDATE OF "SHIP_SETTING", "ID", "RMV_ID", "EIISFRAG_ID"
ON "EIIS_TEST"."SHIP_SETTINGS"
FOR EACH ROW
Declare
v_master_id number;

Begin

If updating ('SHIP_SETTING') then
-- insert into audit table

elsif updating ('ID') then
-- insert into audit table

..
But what if both of these columns are updated? The code will just do the first insert and then end (I think). Any ways that I am not seeing. As you can probably tell I am pretty new to PL/SQL .