mercredi 7 janvier 2015

How to create script file with PL/SQL?


I have to update several objects in many instances. In order to achieve that I am using DBMS_METADATA to create the DDL statements.


So far I have the DDL statements and I save them in a TABLE. I would like to save said DDL statements in a .sql file for each object.


I know I can do this with C#, but so far I have been able to achieve everything I needed to do with PL/SQL. Is there a way to create the .sql files with PL/SQL?





Aucun commentaire:

Enregistrer un commentaire