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.
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.