-
how to write this procedure in pl/sql
I have a DML trigger on a table. whenever there is a change to the table, the old records will be written to another backup table created before. I want to implement this for many tables in the database. Basically, I want a procedure that takes table name as an input and creats a backup table and a trigger for the input table.
How to write such procedure?
thanks.
-
Originally Posted by z3k2
I have a DML trigger on a table. whenever there is a change to the table, the old records will be written to another backup table created before. I want to implement this for many tables in the database. Basically, I want a procedure that takes table name as an input and creats a backup table and a trigger for the input table.
How to write such procedure?
thanks.
You can not query the metarows that describe the old and new values. therefore you can not create dynamic triggers to log changes. However, using dba_tab_columns you can dynamically create static triggers that will update your history.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|