Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. 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>