Globalization In ORACLE APEX [Arabic] with English subtitle

1. Application Primary Language

2. Application Language Derived From

3. Document Direction

1. Application Date Format

2. Application Date Time Format

3. Application Timestamp Format

4. Application Timestamp Time Zone Format

1. Character Value Comparison

2. Character Value Comparison Behavior

3. Automatic Time Zone

4. Automatic CSV Encoding

• No NLS (Application not translated)
  - Select this option if the application will not be translated.

• Application Primary Language
  - Determines the translated application language based on the Application Primary Language attribute.

• Browser (use browser language preference)
  - Determines the translated application language based on the user's Web browser language.

• Application Preference (use FSP_LANGUAGE_PREFERENCE)
  - Determines the translated application language based on a value defined using the APEX_UTIL.SET_PREFERENCE API. This option can be used to maintain a user's language preference across multiple logins.
  APEX_UTIL.SET_PREFERENCE(

      p_preference => 'FSP_LANGUAGE_PREFERENCE',

      p_value => 'ar-eg');

• Item Preference (use item containing preference)
  - Determines the translated application language based on an application-level item called FSP_LANGUAGE_PREFERENCE. Using this option requires Application Express to determine the appropriate language preference every time the user logs in.
  :FSP_LANGUAGE_PREFERENCE := :P9999_LANGUAGE ;

• Session
  - Determines the translated application language from the session setting. The Application Express session language can be set via either the APEX_UTIL.SET_SESSION_LANG procedure or via the P_LANG parameter of the F procedure in the URL.
  
  apex_util.set_session_lang('ar-eg');

Dynamic translations enable custom PL/SQL code to perform translations using the APEX_LANG.LANG function.
This table maps values from the primary language to another national language.