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.