TIMESTAMP literal supports Time Zone (as offset from UTC). Default is SESSION Timezone
SQL> SQL> DECLARE 2 3 v1 DATE; 4 v2 TIMESTAMP; 5 v3 TIMESTAMP WITH TIME ZONE; 6 v4 TIMESTAMP WITH LOCAL TIME ZONE; 7 8 BEGIN 9 10 11 v3 := TIMESTAMP '2002-11-03 03:00:00 -07:00'; 12 dbms_output.put_line(v3); 13 14 END; 15 / 03-NOV-02 03.00.00.000000 AM -07:00 PL/SQL procedure successfully completed. SQL>