Universal SQL Editor 1.1.4

Universal SQL Editor 1.1.4 is such a useful tool which is designed to help users connect any ODBC compliant databases easily.

Universal SQL Editor is a powerful, yet easy-to-use graphical query tool for all database developers. It allows you connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, etc., and edit SQL queries and scripts with code completion, tooltip information, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.

Major Features:

1. Flexible Connectivity
   
   • Support ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, etc.
2. Easy Database Object Manipulation
   
   • Support scripting database objects (Support Oracle, DB2, SQL Server and Sybase only)
   • Support long script execution. If script was executed from the beginning to the end and error has occurred, the statement where the error occurred will be highlighted
   • Objects in database explorer will be updated automatically after execution of DDL statements
3. Powerful SQL Editor
   
   • Recognize complex SQL syntax, such as, derived table, common table expression (CTE), nested query, etc.
   • Support syntax highlighting, code completion and tooltip information
   • Support SQL formatting; include letter case conversion, for example, "TitleCase", "camelCase", etc.
   • Support line revision marks, split view, full screen edit, drag-and-drop edit, column mode edit, code folding, widlcard search and replace, multiple levels of undo and redo, Unicode and DOS/UNIX/MAC formatted files
4. Convenient Query Tool
   
   • Allow editing, grouping, searching, filtering and sorting
   • Table and record views to see data the way you like it
   • Query results can be exported to Excel spreadsheet or as a set of SQL statements
5. Other Useful Features
   
   • Convenient to view information on dependencies between database objects (Support Oracle, DB2, SQL Server and Sybase only)
   • Low memory consumption
   • Additional features can be implemented as plug-in DLLs

Enhancements:

• Improves SQL formatting and Oracle support.
  
• Supports wildcard search