ThatJeffSmith

How I Setup SQL Developer to Look and Run

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.