DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Question

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    123
    Hi,

    I saw in docus: to identify which column is updted in the "after update of col1, col2,.... on table t" database trigger, you can use:
    IF updating('col1') then
    do_1
    ELSIF updating('col2') then
    do_others
    end if;

    Is this true? Or we have to use:
    If :new.col1 <> :0ld.col1 OR (:new.col1 is null and :0ld.....).

    Please help.

    Thanks

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Red face



    Did you test either theory?

    - Magnus

Posting Permissions

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


Click Here to Expand Forum to Full Width