how to write this procedure in pl/sql

[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.

[gandolf989]

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.