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

Name

SET SQLPROMPT — Not available in iSQL*Plus

Synopsis

The SET SQLPROMPT setting changes the SQL*Plus command prompt.

Syntax

SET SQLP[ROMPT] prompt_text

Parameters

SET SQLP[ROMPT]

Is the command, which may be abbreviated SET SQLP.

prompt_text

Is the new prompt text. The default prompt text is "SQL> ".

Examples

The following example shows the prompt being changed from "SQL> " to "SQL*Plus> ":

SQL> SET SQLPROMPT "SQL*Plus> "
SQL*Plus>

In Chapter 14, the section Section 14.2 shows how you can set your prompt to automatically reflect the database to which you are connected.