Better SQL Formatter in Oracle SQL Developer, Finally a Reality
As mentioned on OracleCommunity.net, Oracle SQL Developer 1.5 Early Adopter 1 (EA1) is now available for download. As with any new release, there are new features and bug fixes. But, they are not yet detailed in the release notes.
However, I know that the one feature that I have been eagerly waiting for is finally here, it is the brand new and enhanced SQL Formatter (screenshots below). Not bad at all!
I’ll be using SQL Developer 1.5 as my main SQL and PL/SQL development tool for the next few days and weeks. Let’s see if this release will convince me to ditch Quest’s SQL Navigator.
The Case of Better Readable Code
When you code, you write your programs either in all lower case, all upper case, or a combination of the two. Let’s take PL/SQL for example, almost all PL/SQL programming best practices and coding styles that I’ve come across recommend using upper and lower. The following is an excerpt from the book Oracle PL/SQL Best Practices By Steven Feuerstein: (more…)
SQL formatter in Oracle Raptor
Oracle Project Raptor, a new and free graphical tool that simplifies database development tasks such as browsing database objects, running SQL scripts, and editing PL/SQL statements, has just been released. (more…)
Filed in Oracle with 9 Comments | Tags: formatter, sqlFormat your SQL the easy way
Let’s face it, SQL code is much easier and faster to read and understand when it is formatted, especially when it is a long and complicated SQL statement you are dealing with. Unformatted SQL can be a pain and can take a long time to understand. To feel the pain, take this example: (more…)
Filed in Oracle, Tips with 23 Comments | Tags: formatter, sql
