Time Zone Names

You can obtain all the time zone names from v$timezone_names.

 
SELECT * 
FROM v$timezone_names 
WHERE ROWNUM <= 5 
ORDER BY tzabbrev;

1. What is Time Zone
2. Database Time Zone
3. Session Time Zone
4. Time Zone Names