Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Assignment value to DATE type variable during declaration

SQL> SQL> SET ECHO ON SQL> SET SERVEROUTPUT ON SQL> DECLARE   2    age   DATE := TO_DATE ('12-1-2000','mm-dd-yyyy');   3   4  BEGIN   5    DBMS_OUTPUT.PUT_LINE('age:');   6    DBMS_OUTPUT.PUT_LINE(age);   7  END;   8  / age: 01-DEC-00 PL/SQL procedure successfully completed. SQL>