December 2002
Intermediate to advanced
928 pages
85h 29m
English
ACC[EPT] user_variable [NUM[BER] | CHAR | DATE] [FOR[MAT] format_specification] [DEF[AULT] default_value] [PROMPT prompt_text | NOPR[OMPT]] [HIDE]
Gets input from a user. ACCEPT is not supported in iSQL*Plus. The syntax for the ACCEPT command has evolved significantly with the past few releases of SQL*Plus. The syntax shown here is valid for Oracle8i and higher. Not all of the clauses are available when using prior versions.