10 Seconds to Save You Many Minutes – Default Export Options

thatjeffsmith SQL Developer 2 Comments

Tell Others About This Story:

As much as I like the Export Comments, or hints

SELECT /*insert*/ * FROM hr.employees

or the less intrusive SET SQLFORMAT insert…

sometimes you just NEED to use the Export feature tied to a grid.

Did you know you can pre-select the defaults? For example, if 9x out of 10, you send the output directly to the Worksheet, and if most of the time you work with JSON, then why not set those up?

That’s a lot fewer clicks, and not as much time looking at the export dialog.

Preferences, Database, Utilities, Export

I usually forget to set the right file encoding, now if I set it up right here, I don't have to worry about it again.

I usually forget to set the right file encoding, now if I set it up right here, I don’t have to worry about it again.

Run my query…Export.

The dialog is already pre-filled with what I want to work with.

The dialog is already pre-filled with what I want to work with.

Preferences

Now you don’t have to look at EVERY option in SQL Developer, but the more time you spend in here the happier your experience will be.

Here’s another few preferences to take a look at.

Tell Others About This Story:

Comments 2

  1. Hi Thanks for the tip. I’ve set mine to default to Excel. I’m wonder if there is a way to customize the file name? It currently shows export.xlsx, but if I could have a date/timestamp just to make it unique so I don’t overwrite existing exports?

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *