SQL statement terminators

By default, the SQL and XQuery editor uses a semicolon ( ; ) as the default statement terminator. You can change the default statement terminator or specify a different statement terminator for the SQL statements in a script that you create in the SQL and XQuery editor.

A statement terminator applies to all of the SQL statements that are in the script in which you specify the statement terminator. You can specify different statement terminators in different SQL scripts. The statement terminator can be a string of one or more case-sensitive characters. If you specify a string of multiple characters 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 script persists every time that you open the script in the SQL and XQuery editor.

If you specify a statement terminator other than the default, a comment is added to the top of the SQL script that indicates the statement terminator that you specified. Existing occurrences of the default statement terminator are not updated in the SQL script; you must change them manually.

You can change the SQL statement terminator in the following situations:

Feedback