If you want to change the statement terminator for all SQL statements, change the default statement terminator on the SQL and XQuery Editor page in the Preferences window ( ).
A statement terminator applies to all of the SQL statements that are in the script in which you specify it. 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 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.
Prerequisite: The SQL script for which you want to change the statement terminator must be open in the SQL and XQuery editor.To change the statement terminator for the SQL statements in an SQL script: