V$TIMEZONE_NAMES

V$TIMEZONE_NAMES displays valid time zone names.

Column Datatype Description
TZNAME VARCHAR2(64) Time zone region (for example, US/Pacific)
TZABBREV VARCHAR2(64) Corresponding daylight abbreviation (for example, PDT)