How I Setup SQL Developer to Look and Run

thatjeffsmith SQL Developer 3 Comments

Tell Others About This Story:

I do a lot of live presentations and demonstrations. I’m frequently asked, ‘why does your SQL Developer look that way?’ or ‘How can I make SQL Developer work that way?’

It’s all about the preferences (or options.)

So here’s what you can do if you want to be like me. By the way, I can’t really help you if you want to be like me, that’s a matter for a psychiatry blog.

Here are the out-of-the-box options I tweak:

Visual Stuff

Fonts

I go big, easier for folks to see in demos.

I go big, easier for folks to see in demos.

Grids

The checkboard backgrounds makes the data easier to read, and I like my resultsets pinned by default

The checkboard backgrounds makes the data easier to read, and I like my resultsets pinned by default

Navigation Filters
New for version 4.0, disable the object types you don't use or care about

New for version 4.0, disable the object types you don’t use or care about

Behavior

Automatic stuff OFF

I'll invoke with the keyboard (ctrl+space) thank you very much.

I’ll invoke with the keyboard (ctrl+space) thank you very much.

SQL History Limit
Tools – Preferences – Database – Worksheet – SQL History Limit: I bump this up to 500.

Customer Editor Code Template
See the previous post. I like to add one for my contact info so I can bring it up easily in an editor. You’ll want to add all of yours, of course.

Bonus Tip if you ever do a Presentation

On Windows, go download ZoomIt. It’s free, and it’s awesome.

Tell Others About This Story:

Comments 3

    1. thatjeffsmith Post
      Author

      Thanks Nigel!

      On the pinned result-sets, I would recommend you close them as soon as you’re done with them. Leaving them open, esp if you haven’t fetched all the records yet, could leave open cursors/processes on the server.

Leave a Reply

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