DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: NLS LANGUAGE

  1. 02-22-2001, 10:53 AM #1
    sureshgane
    sureshgane is offline Junior Member
    Join Date
    Sep 2000
    Posts
    56
    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
    Reply With Quote Reply With Quote
  2. 02-22-2001, 11:41 AM #2
    manjunathk
    manjunathk is offline Member
    Join Date
    Oct 2000
    Posts
    211
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width