-
I WANT TO CHANGE THE PRESENT NLS_LANGUAGE WHICH IS IN AMERICAN TO FRENCH FOR TESTING OF A RECORD HOW TO DO THAT FOR A SESION.I DID ALTER SESSION SET NLS_LANGUAGE='FRENCH' & I DID SHOW PARAMETER IT STILL SHOWS AMERICAN.WHERE & WHAT I SHOULD CHANGE TO GET THE DESIRED RESULT
-
The parameter is altered in that particular session only.
If you want to make it a permanent change( and only then the change will reflect when you 'show parameter') change it in the init.ora and then restart your database.
hope it helps
manjunath