SQL Pretty Printer 2.9.3

Besides beautify the SQL, it can also translate the SQL into C#, Java, Php and other program languages that is ready to use in your program.

SQL Pretty printer is designed to deal with SQL statement used by different Database Such as Oracle, DB2, Informix, Sybase, Postgres, MySQL and so on.

Major Features:

1. Beautifies SQL statements utilizing highly customizable format options.
2. Formats SQL on-the-fly in popular tools and editors using hotkey functionality.
3. Minimizes to the system tray for quick access.
4. Includes a command line for batch conversion of single files, single directories or directory trees (use the command line API in your own program!)
5. Verifies SQL syntax with detailed error information.
6. Converts monochrome SQL code into colorful HTML for easy placement in blogs and forums.
7. Converts SQL to various programming languages including C#, Java, DELPHI, PHP and others.
8. Currently supports SQL syntax for Microsoft SQL Server, Oracle, IBM DB2, MySQL and Microsoft Access (Informix, Sybase, and PostgreSQL support is currently in development).
9. Add-In for SQL Server Management Studio available.
10. Add-In for Visual Studio 2003/2005/2008 available.

Enhancements

• [format options] Added: case option for quoted_identifier( [ident] or "ident"). case option for datatype. List style for insert column and value list. CaseWhenThenInSameLine for case statement.
• [oracle] Added: support for create materialized view, create materialized view log on.
• [oracle] added: supported of PRAGMA AUTONOMOUS_TRANSACTION
• [oracle] enhanced: nocycle is supported in hierarchical_query_clause.
• [oracle] added: plsql create type was supported.
• [oracle] added: forward function/procedure declaration in package body was supported.
• [oracle] added: interval expression was supported.
• [sqlserver] improved: support multiple compute by clause.
• [sqlserver] added: In table definition, add support for PERSISTED on a computed column.

Requirements:

• Pentium class CPU or higher