Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NLS_LANG

Re: NLS_LANG

From: Gorm Larsen <gorm_larsen_at_jyde.dk>
Date: Wed, 26 Jan 2000 22:13:50 +0100
Message-ID: <MPG.12f981f7aabfd57b98968b@valhal>


In article <38900FBB.949AF5D1_at_caput.com>, morten_at_caput.com says...
> Are the other ways to set NLS_LANG than by setting
> an environment variable? First, I had
> NLS_LANG=Danish.WE8ISO8859P1 which should allow

Take a look at the documentation for NLS* parameters.

Put:

NLS_LANGUAGE = Danish 
NLS_TERRITORY = Denmark
NLS_DATE_LANGUAGE = Danish
NLS_DATE_FORMAT = 'DD/MM-YYYY'

in your Init????.ora file and restart the database or use Alter session set nls_???? = Danish

--
Gorm Larsen Received on Wed Jan 26 2000 - 15:13:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US