Easy formatting of Oracle SQL Oracle Database Tips by Donald Burleson

Question:  I have some SQL statements gathered from STATSPACK report and v$sql and the formatting is a huge mess.  How can I format the Oracle SQL for readability?  I want to unwrap the SQL and format the SQL in a standard format with the SELECT, FROM and WHERE clause on separate lines.  What's the best tool for formatting Oracle SQL?

Answer:  There are many 3rd party tools for format Oracle SQL, but this one below is highly recommended, largely because it is a Java applet, it works, and it's free. 

Many Oracle experts like Eddie Awads highly recommended tool for Oracle SQL formatting, the SQLinForm tool by Guido Thelen. 

Best of all, SQLinForm is on a web-enabled web page, and nothing needs to be installed (although there is a desktop version for formatting Oracle SQL offline).

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.