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

Name

SET SQLCONTINUE — Not available in iSQL*Plus

Synopsis

The SQLCONTINUE setting controls the prompt used when you continue a statement to a second line, using the SQL*Plus continuation character.

Syntax

SET SQLCO[NTINUE] continuation_prompt

Parameters

SET SQLCO[NTINUE]

Is the command, which may be abbreviated SET SQLCO.

continuation_prompt

Is the new continuation prompt. The default value is ">"—the greater-than character. You may optionally enclose the prompt in either single or double quotation marks.

Examples

The following example shows the effect of changing this setting:

SQL> SET SQLCONTINUE "Continue > "
SQL> DESCRIBE -
Continue >

The SQL*Plus continuation character, a dash, was used following the DESCRIBE command. The continuation prompt is used only when you use the continuation character to continue a command to a new line. It isn't used when you enter a multiline SQL statement.