Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Use select into statement to assign systimestamp to timestamp variable

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>