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