SQL*Plus User's Guide and Reference Release 8.1.6 A75664-01 |
|
Command Reference, 6 of 52
Reads a line of input and stores it in a given user variable.
ACC[EPT] variable [NUM[BER]|CHAR|DATE] [FOR[MAT] format] [DEF[AULT] default] [PROMPT text|NOPR[OMPT]] [HIDE]
Refer to the following list for a description of each term or clause:
variable
NUM[BER]
CHAR
DATE
FOR[MAT]
Specifies the input format for the reply. If the reply does not match the specified format, ACCEPT gives an error message and prompts again for a reply. The format element must be a text constant such as A10 or 9.999. See the COLUMN command in this chapter for a complete list of format elements.
Oracle date formats such as "dd/mm/yy" are valid when the datatype is DATE. DATE without a specified format defaults to the Oracle NLS_DATE_FORMAT of the current session. See the Oracle8i Administrator's Guide and the Oracle8i SQL Reference for information on Oracle date formats.
DEF[AULT]
PROMPT
text
HIDE
To display or reference variables, use the DEFINE command. See the DEFINE command in this chapter for more information.
To display the prompt "Password: ", place the reply in a CHAR variable named PSWD, and suppress the display, enter
SQL> ACCEPT pswd CHAR PROMPT 'Password: ' HIDE
To display the prompt "Enter weekly salary: " and place the reply in a NUMBER variable named SALARY with a default of 000.0, enter
SQL> ACCEPT salary NUMBER FORMAT '999.99' DEFAULT '000.0' - > PROMPT 'Enter weekly salary: '
To display the prompt "Enter date hired: " and place the reply in a DATE variable named HIRED with the format "dd/mm/yy" and a default of "01/01/99", enter
SQL> ACCEPT hired DATE FORMAT 'dd/mm/yy' DEFAULT '01/01/99'- > PROMPT 'Enter date hired: '
To display the prompt "Enter employee lastname: " and place the reply in a CHAR variable named LASTNAME, enter
SQL> ACCEPT lastname CHAR FORMAT 'A20' - > PROMPT 'Enter employee lastname: '
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|