How to Save a Package and Package Body to a .SQL File

Tell Others About This Story:

Got this question:

Hello @thatjeffsmith ! How I save packege body and packege spec in same archive? #SqlDeveloper

— Felipe Pereira (@FelipeR_Pereira) April 27, 2017

Answer: YES.

Make sure you select BOTH.

Then set your file type.

.SQL as requested

Now to confirm I’m really getting what I want.

Yes, that.

SQL Developer will automatically open the file after it’s created.

Voila!

Leave a Reply