Re: NLS_LANG

torfridl_at_ulrik.uio.no (Torfrid Leek) wrote:

>You can set NLS_LANGUAGE and NLS_TERRITORY in init.ora.
>For the session you can set NLS_LANG, which is a combination
>of these 2 and character set.
>Beware: If you have syntax errors the default (AMERICAN_AMERICA.US7ASCII)
>is used!
>Regards, Torfrid

To alter a session only, see

ALTER SESSION

     SET   NLS_LANGUAGE           =   language 
         | NLS_TERRITORY          =   territory 
         | NLS_DATE_FORMAT        =  'fmt' 
         | NLS_DATE_LANGUAGE      =   language 
         | NLS_NUMERIC_CHARACTERS =  'text' 
         | NLS_ISO_CURRENCY       =   territory 
         | NLS_CURRENCY           =  'text' 
         | NLS_SORT               = { sort  | BINARY } 

>torfrid.leek_at_usit.uio.no

Standard disclaimers apply Received on Mon Feb 12 1996 - 00:00:00 CET