accept x prompt 'Enter date[yyyy-mm-dd]: ' : ACCEPT « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. ACCEPT

SQL>
SQL>
SQL> accept x prompt "Enter date[yyyy-mm-dd]: "
Enter date[yyyy-mm-dd]:
SQL> select date '&x' as input_date
  2  ,      to_char(date '&x', 'ww') as ww
  3  ,      to_char(date '&x', 'iw') as iw
  4  from   dual;
old   1: select date '&x' as input_date
new   1: select date '' as input_date
old   2: ,      to_char(date '&x', 'ww') as ww
new   2: ,      to_char(date '', 'ww') as ww
old   3: ,      to_char(date '&x', 'iw') as iw
new   3: ,      to_char(date '', 'iw') as iw
select date '' as input_date
            *
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0


SQL>
SQL> undefine x
SQL>