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

Thread: triggers on tables

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi, all
    Does anybody have a trigger on certain tables' update and delete actions. the column would contain the Oracle User id, O/S id,time the data changed. Thanks for help.

    Dragon

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No problem with update. But with delete, I can not see where do you want the information to be written to! The row will not exist any more, so where would you append your information about the user and the deletion date to? Unless you want to save the row to another archive table before it gets deleted from the actual table?

    For update:
    CREATE OR REPLACE emp_bur_trigger ON scott.emp BEFORE UPDATE FOR EACH ROW
    BEGIN
    --:NEW.update_user := USER;
    --:NEW.update_date := SYSDATE;
    END;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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