Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc
Requirements: ODBC Driver
Universal SQL Editor is a Development software developed by Ming Software. After our trial and test, the software is proved to be official, secure and free. Here is the official description for Universal SQL Editor:
EditByBrothersoft: Universal SQL editor is a lightweight Intellisense-enabled database query tool.
It allows you connect Oracle, DB2, SQL Server, Sybase, Informix, and any ODBC compliant database, and edit complex SQL with Intellisense-like autocompletion, Highlight references, parameter hinting, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.
In additional, query results returned by this query tool supports grouping, filtering, searching, and can also be exported to Excel Spreadsheet or as a set of SQL Statements.
Following list describes the main features of Universal SQL Editor:
* Support Oracle, DB2, SQL Server, Sybase and other ODBC compliant databases
Easy Database Object Manipulation
* Support scripting database objects (Support Oracle, DB2, SQL Server and Sybase only)
* Support long script execution. If execution was from the beginning to the end and error has occurred, statement causes the error will be highlighted
* Objects in database explorer will be updated automatically after execution of DDL statements
Powerful SQL Editor
* Recognize complex SQL syntax such as, derived table, common table expression (CTE), nested query, etc.
* Support Intellisense-like code completion, parameter hinting and tooltip information
* Support highlight references of table, column, cursor, variable, etc.
* Support SQL formatting; include letter case conversion, for example, "TITLECASE" -> "TitleCase", "CAMELCASE" -> "camelCase", etc.
* Support line revision marks, column selection, column mode edit, code folding, split view, full screen edit, drag-and-drop edit, wildcard search and replace, multiple levels of undo and redo, Unicode and Windows / UNIX / MAC formatted text files
Convenient Query Tool
* Support grouping, filtering, searching, editing and sorting
* Table and record views to see data the way