
Generally speaking, when SQL Developer is doing something you don’t like, there’s an option for that. Let’s look at a very quick example, Prior to Version 4.2: Raw, Unformatted SQL Hard to read, much?Ĭtrl+F7 = Presto-changeo! Formatted SQL Better? But My Formatter is Broken! This generally comes down to good management of whitespace. One of the many code ‘helpers’ that a good IDE will provide is a Formatter.įormatters, or code beautifiers as they’re also known, take poorly formatted text and make them readable again.

Oracle SQL Developer is at its heart, an Interactive Development Environment (IDE.) So it comes with the territory that developers should expect to be able to write good code quickly.
