Mostly Making oracle easy, mostly:
Search for:
In SQL Developer

10 Seconds to Save You Many Minutes – Default Export Options

1 Min Read

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.

Author

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

Related Posts

2 Comments

  1. sun Reply

    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?

Reply To sun Cancel Reply