Sunday, September 28, 2014

How to change Language To Arabic in Toad Oracle

Step 1: Check what NLS_LANGUAGE is being used in your database.

SELECT    (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_LANGUAGE')
       || '_'
       || (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_TERRITORY')
       || '.'
       || (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_CHARACTERSET') LANGUAGE
  FROM DUAL




Step 2: Change the NLS _ LANGUAGE in Toad to the same.
Step 3: Open Toad
Step 4: Click on the button as shown below




Step 5 : Click on the current  NLS_LANGUAGE
Sept 6 : Change it according to the database.
Sept 7 : Save the changes and close toad application then start again.

 Now Connect to the database...


2 comments:

  1. Hi,

    I had did same like your procedure its changing there but its not changing table which you give to first.. after change when i am checking through your but showing old one and i think that's why arabic language is showing old one. so please advice me how can i change in table.. thanks..

    ReplyDelete