Name

PROMPT

Synopsis

The PROMPT command displays a message for the user to see. See Chapter 8 for more information.

Syntax

PRO[MPT] text_to_be_displayed

Parameters

PRO[MPT]

Is the command, which may be abbreviated PRO

text_to_be_displayed

Is whatever text you want displayed to the user. This should not be a quoted string. If you include quotes, they will appear in the output.

Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.