Today I found a nice little Java tool to help format long SQL queries. It has many options on how the string will be formatted. It will also take sql input types such as:

• SQL
• DB2/UDB
• Oracle
• MSAccess
• SQL Server
• Sybase
• MYSQL
• PostgreSQL
• Informix

It then can take this input SQL and format it into a different type such as:

• SQL
• Java StringBuffer
• Java String
• C# StringBuilder
• PHP String
• ASP StringBuilder
• VB String
• VB StringBuilder
• Concatenated SQL
• HTML Code

This tool really has a lot of options and is very handy when trying to read/edit a long SQL query.