SQL editor

You can create an SQL statement using the SQL editor in the Data perspective. The tool supports the creation of one or more statements. Any statements that you create and save are stored in a file with the extension .sql.
The SQL editor provides the following features:
Multiple statement support
You can type multiple statements in an .sql file and then run them.
Variable statement terminator
By default, the SQL editor uses a semicolon ( ; ) as the default statement terminator. You can specify a different statement terminator for the SQL statements that you create in the SQL editor.
Syntax highlighting
To aid you in differentiating the elements in an SQL statement, syntax highlighting renders different kinds of elements in the SQL text in unique colors.
Content assist
Content assist is an editing tool that provides you with helpful information as you type an SQL statement. After you type the period that follows a schema qualifier, content assist supplies a list of the tables in the schema. Content assist also supplies a list of columns for a given table.

The SQL editor does not support the use of host variables in SQL statements.

Related tasks
Changing the SQL statement terminator
Creating SQL statements in the SQL editor by using the File menu
Creating SQL statements in the SQL editor by using a data project
Creating SQL statements in the SQL editor by using a physical data model
Creating SQL statements in the SQL editor by using a database connection
Creating SQL statements in the SQL editor by using the Database Explorer toolbar

Feedback