SQLPlus Accept

The ACCEPT command reads a line of input and stores it in a given user variable.

ACCEPT Command Syntax:

ACC[EPT] variable [NUM[BER]|CHAR|DATE] [FOR[MAT] format] [DEF[AULT] default]
[PROMPT text|NOPR[OMPT]] [HIDE]

ACCEPT Command Examples:

ACCEPT pswd CHAR PROMPT ‘Password: ‘ HIDE
ACCEPT amount NUMBER FORMAT ‘999.99’ DEFAULT ‘000.0’ – PROMPT ‘Insert amount offer: ‘
ACCEPT offer_date DATE FORMAT ‘dd/mm/yyyy’ DEFAULT ’01/12/2011′- PROMPT ‘Insert offer date: ‘