Oracle PL/SQL Tutorial/System Tables Data Dictionary/timezone names

Obtaining Time Zone Names by selecting all the rows from v$timezone_names

You have to be the system user.

SQL>
SQL> SELECT * FROM v$timezone_names;
TZNAME                                               TZABBREV
---------------------------------------------------- ---------------------------
Africa/Algiers                                       LMT
Africa/Algiers                                       PMT
Africa/Algiers                                       WET
Africa/Algiers                                       WEST
Africa/Algiers                                       CET
Africa/Algiers                                       CEST
Africa/Cairo                                         LMT
Africa/Cairo                                         EET
Africa/Cairo                                         EEST
...
...
...

You can use value in the TZABBREV column as your time zone setting.