Embarcadero Rapid SQL XE4

General features

• Multi-platform support - supports all major DBMSs from a single interface. Ability to use the tools on all supported platforms from a single license.
• Embarcadero AppWave - enables centralised licence management and tool deployment.
• Unicode support - full Unicode character support throughout the application.
• Intuitive interface - automates common and repetitive tasks with easy-to-use SQL editors and wizards.

SQL scripting and editing

• Visual query builder - constructs even the most complicated SQL statements with point-and-click ease.
• Code templates - eliminates the need to memorize and type SQL syntax.
• SQL editor - code folding, code collapse/roll-up, syntax coloring, hot key assignments, configurable auto replace of objects, bind variable support, selective statement execution.
• Content-sensitive DMBS actions - DBMS actions, such as Extract and Drop, are available directly in the context menu of the appropriate tokens in the SQL editor.

Debugging and performance optimisation

• Code analyst - performs detailed response time analysis on the execution of stored procedures and functions.
• SQL debugger - debugs programmable objects such as stored procedures, functions, packages, and triggers. Available for DB2 for LUW, Oracle, SQL Server and Sybase.
• SQL profiler - captures metrics of various PL/SQL programmable objects on Oracle 8.1.5 and higher.

Developer features

• Advanced code assist - lists context-sensitive suggestions as you type (e.g., tables, columns, procedures, functions, and code templates) and is available offline.
• Code formatting and profiles - code folding, syntax coloring, comment toggling, and other auto formatting features make it easy to read, navigate, and edit large SQL files. Customise and share various SQL formatting options by creating SQL formatting profiles.
• Context-sensitive DBMS actions - DBMS actions, such as Extract and Drop, are available directly in the context menu of the appropriate tokens in the SQL editor.
• Syntax and semantic validation - validate SQL files and flags all DBMS-specific parser violations or references to objects not found in the target database.
• Quick fixes - real-time parsing provides code quality suggestions for improving SQL performance as you type.
• SQL debugging - debug Java, step seamlessly into SQL (i.e. stored procedure) and back into Java again ¿ true system-wide, round-trip debugging.