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