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.

Voila!
thatjeffsmith
Author

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.

7 Comments

  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