Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Define DATE type variable

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