1
Download SQL*Plus User's Guide and Reference
Transcript
PAUSE
PAUSE
Syntax
PAU[SE] [text]
where text represents the text you wish to display.
Displays the specified text then waits for the user to press RETURN.
Enter PAUSE followed by no text to display two empty lines.
Usage
Because PAUSE always waits for the user's response, it is best to use a message that
tells the user explicitly to press [Return].
PAUSE reads input from the terminal (if a terminal is available) even when you have
designated the source of the command input as a file.
See SET PAU[SE] {ON | OFF | text} on page 12-136 for information on pausing
between pages of a report.
Examples
To print "Adjust paper and press RETURN to continue." and to have SQL*Plus wait
for the user to press [Return], you might include the following PAUSE command in a
script:
SET PAUSE OFF
PAUSE Adjust paper and press RETURN to continue.
SELECT ...
12-70 SQL*Plus User's Guide and Reference
