CODEWITHSUNDEEP
oracle-databaseplsql
Serkan Kasapbaşı
Serkan Kasapbaşı

Reputation: 409

Is it possible to extract ddl of a package without package body

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

Upvotes: 9

Views: 16943

Answers (2)

Hans
Hans

Reputation: 11

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.

Upvotes: 1

GôTô
GôTô

Reputation: 8053

Try dbms_metadata.get_ddl('PACKAGE_SPEC', some_package instead) (there is similar with PACKAGE_BODY)

Upvotes: 18

Related Questions