You can create an SQL scrapbook page by using the SQL editor. The
tool supports the creation of one or more SQL statements in an SQL scrapbook
page. A SQL scrapbook page that you create and save is stored in a file with
the extension .sqlpage.
The SQL editor provides the following features:
- Multiple statement support
- You can type multiple statements in an .sqlpage 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.