UTL_I18N
UTL_I18N.GET_LOCAL_LANGUAGES
DECLARE
   l_array  UTL_I18N.STRING_ARRAY;
   idx      PLS_INTEGER;

BEGIN
 l_array := UTL_I18N.GET_LOCAL_LANGUAGES('INDIA');

 DBMS_OUTPUT.ENABLE(100000);
 DBMS_OUTPUT.PUT_LINE('Language Count = '||
    l_array.COUNT);

 idx := l_array.FIRST;

 WHILE idx < l_array.COUNT LOOP
   DBMS_OUTPUT.PUT_LINE(LPAD(idx,2,'0')||' '||
      l_array(idx));
   idx := l_array.NEXT(idx);
 END LOOP;

END;
/
PL/SQL - Local Languages

UTL_I18N -> Local Time Zones

Oracle registered trademark of Oracle Corporation.

Last Revised on: February 23, 2012

  70035