The SQL Editor supports Oracle PL/SQL, PostgreSQL PL/pgSQL, DB2, MySQL, SQL Anywhere Watcom SQL, and Transact-SQL scripts. This section uses Oracle PL/SQL script as an example to describe the SQL Editor’s script support.
For Oracle databases, the SQL Editor allows users to execute anonymous PL/SQL blocks and any statements to create triggers, stored procedures, and packages.
If there are any compilation errors in a trigger, stored procedure or package, after execute the create statement, the compilation errors will be displayed as error markers in the editor. Positioning the cursor on an error marker, the compilation error will be displayed as a popup tool tip.
The SQL Editor also allows users to execute anonymous PL/SQL blocks with calls to dbms_output package to print out debugging messages.