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>