Geek asks and answers

Export specification and body to one file

I am using SQL Developer 3.0.04 and trying to export a package. I have 2 questions:

  • Is it possible to export both the package specification and the body into one export (the result is 1 export.sql file)?

  • The export.sql file is somewhat compressed, in some way I can have it in text format using linefeeds etc. so that I can read it better?

+5
source share
4 answers

In SQL-Developer, right-click the package specification and select Save Package Spec and Body.... This will generate a single file with both spec and body.

+6
source

, , \Tools\Database Export .

+1

, . → export → " "

export.sql .

, DDL ( ); .

, , sql, + , .

0

: " "

0

More articles:


All Articles