Name

ACCEPT

Synopsis

ACC[EPT] var [type] [PROMPT text | NOPROMPT] [HIDE]

Reads a line of input and stores it in the variable var.

type

Restricts the type of input allowed; may be either NUMBER or CHAR.

PROMPT

If specified, displays text on the screen before accepting input.

NOPROMPT

If specified, does not display text on the screen before accepting input.

HIDE

Prevents input from being displayed on the screen.

Get Oracle Database Administration: The Essential Refe now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.