Can You Format My Code, This Way?

thatjeffsmith SQL Developer 3 Comments

A follower reached out to me late yesterday with this request: And the answer is yes, we can pretty much get there. I’ve noticed a few things by looking at his hand-formatted code on the bottom section. He prefers: everything lowercase right-aligned keywords no line breaks for the sub query ()’s no line breaks after SELECT/FROM/WHERE keywords So let’s go …

Four Minute Video Tip: Configuring SQL Developer for the First Time

thatjeffsmith SQL Developer 1 Comment

You’ve just installed a new copy of SQL Developer. Here are some things you might want to change in the preferences. Notes: I said ‘fixed field’ – I meant FIXED WIDTH fonts, duh If you think you’re hearing Foreigner’s Feels Like The First Time, you’re wrong Some of the tips in blog format: fonts zebra line numbers open on SINGLE …

How to Reset Your SQL Developer Preferences/Settings

thatjeffsmith SQL Developer 7 Comments

We store the application settings PER user. So find where your OS stores files for your OS user. These settings are stored HERE on Windows (…AppData\Roaming\SQL Developer): They are stored HERE on Macs and *NIX ($HOME\.sqldeveloper): Find the directory that corresponds with the version you are running and having problems with. Rename it. Restart SQL Developer – you should be …

30 SQL Developer Posts in 30 Days, Day 29: Preferences I Always Change on a New Install

thatjeffsmith SQL Developer 11 Comments

Updated Wednesday, July 6, 2016 Setting up a new install of SQL Developer this morning – exciting stuff as we’ll be teasing some v4.1 features at Open World this week – I found myself immediately tweaking the following preferences. Font – we’ve talked about this a few times, but I make it bigger to make it easier to see in …