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
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 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.
Sept 7 : Save the changes and close toad application then start again.
Now Connect to the database...
Hi,
ReplyDeleteI 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..
worked. thanks :)
ReplyDelete