SET SERVEROUTPUT ON;

DECLARE
   l_array  UTL_I18N.STRING_ARRAY;
   idx      SIMPLE_INTEGER :=0;

BEGIN
  DBMS_OUTPUT.ENABLE(100000);

  l_array := UTL_I18N.GET_LOCAL_TIME_ZONES('AMERICA'); 

  DBMS_OUTPUT.PUT_LINE('Time Zone Count = '||
     l_array.COUNT);

  FOR idx IN l_array.FIRST ..l_array.LAST LOOP
    DBMS_OUTPUT.PUT_LINE(idx||' '||l_array(idx));
  END LOOP;

END;
/




-- For Complete Oracle TimeZones Listing

DECLARE
   l_array  UTL_I18N.STRING_ARRAY;
   idx      SIMPLE_INTEGER :=0;

BEGIN
  DBMS_OUTPUT.ENABLE(100000);

  l_array := UTL_I18N.GET_COMMON_TIME_ZONES; 

  DBMS_OUTPUT.PUT_LINE('Time Zone Count = '||
     l_array.COUNT);

  FOR idx IN l_array.FIRST ..l_array.LAST LOOP
    DBMS_OUTPUT.PUT_LINE(idx||' '||l_array(idx));
  END LOOP;
END;
/