Mega Code Archive
Declare date type variable and set the value at the same time
SQL>
SQL>
SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
2 v_date DATE := DATE '2004-06-05';
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE(v_date);
5 END;
6 /
05-JUN-04
PL/SQL procedure successfully completed.
SQL>
SQL>