Menu
I am using dbms_metadata.get_ddl function. I extract ddl of package and package body seperate and use them separately, so i dont need PACKAGE BODY's ddl when i ask for PACKAGE ddl. However get_ddl('PACKAGE',some_package) returns PACKAGE and PACKAGE BODY's ddls together. Is there a parameter to set, or anything else to make this possible...
948
You can get any package's get ddl ( create script ) as follows. SQL> SELECT DBMS_METADATA. GET_DDL('PACKAGE','OBJECT_NAME','SCHEMA_NAME') FROM DUAL; You can get any package's body get ddl ( create script ) as follows.
To get the source of a stored procedure: select dbms_metadata. get_ddl('PROCEDURE', 'SOME_PROC') from dual; Using that you can create a SQL script that extracts everything and then spool the result to a file.
Try dbms_metadata.get_ddl('PACKAGE_SPEC', some_package instead) (there is similar with PACKAGE_BODY)
105
For a well formated ddl extraction and easy to use you can get ZoraDDL. This is a little commandlinetool to extract DDL from the Database with many features. Look at ZorraDDL Homepage for more Information.
32
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
