SQL or PL/SQL Editor

Features and Functionality

Colored syntax SQL Editor allows you to write any SQL statement and make database queries.
It supported single and multiple execution mode and the possibility to save result in the export file.
Suport most of oracle new datatype example object, nester table, bfile,varray, ..

You can easily edit and execute individual or multiple SQL/PLSQL statements using the SQL editor. You can submit any SQL statement, including DML and DDL statements. When a SELECT statement is executed, the rows returned are displayed in a data sheet format.
You can edit the data returned by SELECT statements if the Updateable Query option is turned on. SQL Editor for oracle to turn on the Updateable Query option.

To open the SQL editor
Click the SQL Editor button on the Functions toolbar
Click Tool > New SQL Editor
press CTRL+N

You can enter multiple SQL statements in the SQL script. Each SQL statement must end with either semicolon (;) or “ / ” .

Execute SQL
You can execute select SQL or execute multiple SQL by press F9 (Ctrl-R for Mac) or Click SQL Editor for oracle on the toolbar.

SQL Editor allow you select single or multiple SQL to execute by highlighting the complete sql statement,then press F9 (Ctrl-R for Mac) or or Click SQL Editor for oracle on the toolbar.
Without highlighting the sql statement, SQL Editor will execute ALL the sql statement in script.

Using Bind variables

A bind variable is a variable in a SQL statement that must be replaced with a valid value for the statement to successfully execute.

The SQL Editor supports bind variables; use them the same way as you would use them in SQL*Plus.

Here is an example of how to declare a bind variable:

SELECT * FROM EMP WHERE emp_id = :id

To reference a bind variable in a SQL, preface it with a colon ( : )

Result for SQL Editor
This result becomes available after the query is executed.It depend on query Type. For SELECT Query,it displays the result data, returned by the query, as a grid or a form. you can edit, export the data.

SQL Editor Data Export
You may export your dataset to one of the following data format:
SQL Script, Text Files, HTML,XML or Windows Clipboard