Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET SQLTERMINATOR

Synopsis

The SQLTERMINATOR setting controls whether SQL*Plus allows you to use a semicolon to terminate and execute a SQL statement. This setting controls the specific character used for this purpose.

Syntax

SET SQLT[ERMINATOR] {OFF | ON | term_char}

Parameters

SET SQLT[ERMINATOR]

Is the command, which may be abbreviated SET SQLT.

OFF

Turns off the feature that allows you to terminate and execute a SQL statement using a semicolon or other character.

ON

Turns on this feature and resets the terminator character to the default value of a semicolon.

term_char

Is the character you want to use as a statement terminator. This may be optionally enclosed in single or double quotation marks.

Examples

The following example changes the terminator character to a percent sign and uses it to terminate and execute a SELECT statement:

SQL> SET SQLTERMINATOR "%"
SQL> SELECT employee_name FROM employee%
EMPLOYEE_NAME
----------------------------------------
Pavlo Chubynsky
Ivan Mazepa
Taras Shevchenko
 . . .