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 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.