By default, the SQL editor uses a semicolon ( ; ) as the default
statement terminator. You can specify a different statement terminator for
an SQL statement that you create in the SQL editor.
A statement terminator is specific to the SQL statement in which
you specify it. You can specify different statement terminators in different
SQL statements. The statement terminator can be a string of one or more case-sensitive
characters. If you specify a string as the statement terminator, the statement
terminator must be preceded by a space in your code.
The statement terminator
that you specify for an SQL statement persists every time that you open the
statement in the SQL editor.
Prerequisite: The SQL statement for
which you want to change the statement terminator must be open in the SQL
editor.
To change the statement terminator for an SQL statement:
- Right-click in the SQL editor, and then click Set Statement
Terminator on the pop-up menu.
- In the Set Statement Terminator window, type one or more characters
to use as the statement terminator and then click OK.
If you specify a statement terminator other than the default, a comment
is added to the top of the SQL statement that indicates the statement terminator
that you specified. Existing occurrences of the default statement terminator
are not updated in the SQL statement; you must change them manually.