Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Use SYSDATE to initialize an DATE type variable

SQL> SQL> SET ECHO ON SQL> SET SERVEROUTPUT ON SQL> DECLARE   2    age   DATE;   3   4  BEGIN   5    age := sysdate;   6    DBMS_OUTPUT.PUT_LINE('age:');   7    DBMS_OUTPUT.PUT_LINE(age);   8  END;   9  / age: 02-JUN-07 PL/SQL procedure successfully completed. SQL>