Features

Following list describes the main features of Universal SQL Editor:

Flexible Connectivity

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

Recognize complex SQL syntax such as, derived table, common table expression (CTE), nested query, etc.
Support Intellisense-like code completion that supports wildcard search, parameter hinting and tooltip information
Support SQL formatting; include letter case conversion, for example, "TITLECASE" -> "TitleCase", "CAMELCASE" -> "camelCase", etc.
Support line revision marks, split view, full screen edit, drag-and-drop edit, column mode edit, code folding, wildcard search and replace, multiple levels of undo and redo, Unicode and DOS/UNIX/MAC formatted files

Allow grouping, filtering, searching, editing 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
Support stack layout result pane like SQL Server query analyzer

Convenient to view information on dependencies between database objects (Support Oracle, DB2, SQL Server and Sybase only)
Fast and low memory consumption
Additional features can be implemented as plug-in DLLs