SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating ddl scripts automatically

maklewis42Feb 22 2006 — edited Feb 22 2006

I have been to look into ways of generating trigger-creating scripts automatically with a database procedure where I supply the table name and a .sql is generated automatically for running against the database. How best can I do this - NDS or dbms_sql . the size of the script will depend on the number of columns in the table for which a trigger is being created.

Can someone paste me an example script

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2006

Added on Feb 22 2006

3 comments

721 views