How to Install Language Version of Oracle Apex 5.0 or 4.2

First, you have to have your Oracle apex already installed (4.2 or 5.0)

Download the oracle apex version (not the apex en.zip, thats the English version)

Extract it and save in the C:/ drive

open the apex folder /open the builder folder
the builder folder you see some language codes de (for German),fr (for french),it(italian) etc

Open your command prompt (cmd)
Go to your directory in the cmd( .. in my case C:/apex/builder)

Language Packs in C:/Apex/builder/

Enter the below code in your command prompt to set the NLS_LANG to your specified language


SET NLS_LANG FRENCH_FRANCE.WE8MSWIN1252

(Here we are adding a French version to our Apex instance, if it were German it'd be set NLS_LANG *****_****.***** see NLS_LANG list here)

Then Check by entering the below code in the cmd
c:\apex\builder>@.[NLS-LANG].
Please note the full stops and the @sign

If you get something like :
unable to pen file ".[FRENCH_FRANCE.WE8MSWIN1252]."
the "filename" between the [] being the language you selected french in our case
It is not an error but the value of the NLS_LANG registry parameter.

Navigate to the language directory you want. Here its french so we want to load so enter
c:\apex\builder\fr>
it'll be c:\apex\builder/de> for German

Log in to SQL*Plus;
c:\apex\builder/fr>sqlplus / as sysdba
Load your language by entering code @load_"your language".sql
c:\apex\builder\fr>@load_fr.sql

if it were german it'd be load_de.sql Then apex should load up. If  you have apex 5.0 you'll see your language option below