Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Colombo, Sri Lanka

    Question Unanswered: Checking updates columns only

    There is an oracle table with 75 columns and as and when any of the column data is being updated, we want to capture the updated columns name,old data and new data.

    We have tried with a DB trigger "before update with row level statement" .But the problem is, we don't know what are the columns that get updated i.e.(out of 75 columns,only some may get updated) and we need to keep a track of that.

    We don't want to add 'if conditions' in DB trigger like

    if ld.columnname<>:new.columnname then
    end if;

    For all the 75 columns....

    Is there any way to identify only the updated columns?"

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1

    Re: Checking updates columns only

    No, you have to test each column. You can also test UPDATING('columnname'), but that only tests whether the column was included in the UPDATE statement, not whether its value was actually changed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts