Thursday, November 28, 2013

auding trigger


DECLARE
L_SQL_STMT  VARCHAR2(6000);
BEGIN
FOR x IN (SELECT * FROM user_tables)
LOOP
  l_sql_stmt :=
    'CREATE OR REPLACE TRIGGER trgMON_' || x.table_name ||
    ' BEFORE INSERT OR UPDATE ON ' || x.table_name ||
    ' FOR EACH ROW ' ||
    'BEGIN ' ||
    '  :new.last_updated_date := sysdate ' ||
    '  :new.last_updated_user := USER ' ||
    'END;';
  dbms_output.put_line( l_sql_stmt );
  --EXECUTE IMMEDIATE l_sql_stmt;
END LOOP;
END;

No comments:

Post a Comment