Previous Next JavaScript must be enabled to correctly display this content

## 6.10 Installing Translated Versions of APEX

Learn about installing translated versions of Oracle APEX.

- About Installing Translated Versions of APEX
  Whether you are installing for the first time or upgrading from a previous release, you must run the `load_``lang``.sql` script to run a translated version of Oracle APEX.
- Installing a Translated Version of APEX
  Learn how to run the appropriate language specific script to install a translated version of Oracle APEX.

See Also:

Managing Application Globalization in Oracle APEX App Builder User’s Guide

Parent topic: Installing and Configuring Oracle REST Data Services and Oracle APEX

### 6.10.1 About Installing Translated Versions of APEX

Whether you are installing for the first time or upgrading from a previous release, you must run the `load_``lang``.sql` script to run a translated version of Oracle APEX.

The APEX developer and admin interface is translated into the 9 standard languages: French, German, Italian, Japanese, Korean, Portuguese (Brazil), Simplified Chinese, Spanish, and Traditional Chinese. Developers can choose to run the APEX development environment in any of the installed languages by simply selecting the language from the Sign In page or home page.

The APEX runtime engine which is used by developers to create applications is available in the following languages: Arabic, Brazilian Portuguese, Croatian, Czech, Danish, Dutch, Finnish, French, French - Canada, German, Greek, Hebrew, Hungarian, Icelandic, Italian, Japanese, Korean, Norwegian, Polish, Portuguese (Portugal) (pt), Romanian, Russian, Serbian - Cyrillic, Serbian - Latin, Simplified Chinese, Slovak, Slovenian, Spanish, Swedish, Thai, Traditional Chinese, Turkish, Ukrainian, and Vietnamese.

Tip:

In fully managed Cloud databases such as Oracle Autonomous AI Database or Oracle APEX AI Application Generator Service (APEX Service), APEX is pre-installed and pre-configured with all languages from the above list. Separate installation of the supported languages is unnecessary.

To support additional languages not covered in the above list, developers must provide their own translations. For example, if you develop a Bulgarian application and want to include report messages, such as pagination, in Bulgarian, you must translate the strings used in messages displayed in reports.

See Also:

Translating Messages Used Internally by APEX in Oracle APEX App Builder User’s Guide

Parent topic: Installing Translated Versions of APEX

### 6.10.2 Installing a Translated Version of APEX

Learn how to run the appropriate language specific script to install a translated version of Oracle APEX.

The installation scripts are located in subdirectories identified by a language code in the unzipped distribution `apex/builder`. For example, the German version is located in `apex/builder/de` and the Japanese version is located in `apex/builder/ja`. Within each directory, there is a language loading script identified by the language code (for example, `load_de.sql` or `load_ja.sql`).

Note:

If you have applied a Patch Set and then install translations, you must re-execute the Patch Set to apply all fixes to the translations.

To install a translated version of APEX:

1. Set the `NLS_LANG` environment variable, making sure that the character set is `AL32UTF8`. For example:

   - Bourne or Korn shell:

         NLS_LANG=American_America.AL32UTF8
         export NLS_LANG

   - C shell:

         setenv NLS_LANG American_America.AL32UTF8

   - For Windows based systems:

         set NLS_LANG=American_America.AL32UTF8

2. Navigate to the directory under `apex/builder` based on the language you need to install. For example for German, navigate to `apex/builder/de`. Start SQLcl and connect to the database where APEX is installed as `SYS` specifying the `SYSDBA` role. For example:

   - On Windows:

         SYSTEM_DRIVE:\ sql /nolog
         SQL> CONNECT SYS as SYSDBA
         Enter password: SYS_password

   - On UNIX and Linux:

         $ sql /nolog
         SQL> CONNECT SYS as SYSDBA
         Enter password: SYS_password

3. Execute the appropriate language specific script. For example:

       @load_lang.sql

   Where `lang` is the specific language (for example, `load_de.sql` for German or `load_ja.sql` for Japanese).

Parent topic: Installing Translated Versions of APEX