You change the statement terminator for all SQL statements by changing the default statement terminator on the SQL and XQuery page in the Preferences window ( ). You change the statement terminator for the SQL statements in an individual script by using either the Command pane or the pop-up menu in the SQL and XQuery editor.
The SQL script for which you want to change the statement terminator must be open 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.
To change the statement terminator for the SQL statements in an SQL script: