Got this question:

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.


I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.


  1. Can we export multiple packages with their bodies with SQL Developer?

  2. Shaun Raven Reply

    I’ve got an interesting problem with this. If I try and export, I only get the package body, not the spec. Also, if I try TomasG’s suggestion, I get a zero length file. Any ideas why this might occur?

    • thatjeffsmith

      Did you select both in the tree? I just tried and it worked for me.

      Can you export the spec by itself?

    • Shaun Raven

      Ah – selecting both worked for me to. That’s good enough.

      Keep up the good work – I love this tool!

  3. Or simply choosing “Save Package Spec and Body…” in context menu

Write A Comment