SQL>
SQL> ALTER SESSION SET TIME_ZONE = '+9:00';
Session altered.
SQL> Session altered.
SQL>
SQL> SELECT
2 DBTIMEZONE db_time,
3 SESSIONTIMEZONE session_time
4 FROM dual;
DB_TIM SESSION_TIME
------ ---------------------------------------------------------------------------
+00:00 +09:00
SQL>