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.

This entry was posted on Thursday, December 7th, 2006 at 10:03 pm and is filed under Software Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.