Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Print the current date and timestamp

SQL> SQL> SET SERVEROUTPUT ON SQL> DECLARE   2     v_sysdate DATE := SYSDATE;   3     v_systimestamp TIMESTAMP := SYSTIMESTAMP;   4     v_date DATE;   5     v_number NUMBER(10);   6  BEGIN   7   8     -- Print the current date and timestamp   9     DBMS_OUTPUT.PUT_LINE(v_systimestamp);  10  11  END;  12  / 03-JUN-07 09.03.58.593000 PM PL/SQL procedure successfully completed. SQL>