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

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

Write A Comment