SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
2
3 v_date_time TIMESTAMP;
4
5 BEGIN
6
7 SELECT systimestamp
8 INTO v_date_time
9 FROM dual;
10
11 DBMS_OUTPUT.PUT_LINE(v_date_time);
12
13 EXCEPTION
14 WHEN OTHERS
15 THEN
16 DBMS_OUTPUT.PUT_LINE(sqlerrm);
17 END;
18 /
03-JUN-07 08.51.26.031000 PM
PL/SQL procedure successfully completed.
SQL>