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

Home -> Community -> Usenet -> c.d.o.server -> Re: NLS Database Parameters vs. NLS Instance Parameters

Re: NLS Database Parameters vs. NLS Instance Parameters

From: Mark Bole <makbo_at_pacbell.net>
Date: Tue, 07 Dec 2004 02:01:15 GMT
Message-ID: <L98td.39454$6q2.13166@newssvr14.news.prodigy.com>


Craig & Co. wrote:
> "Michel Cadot" <micadot{at}altern{dot}org> wrote in message
> news:41b3effc$0$32761$626a14ce_at_news.free.fr...
>

>>"Craig & Co." <crb_at_amsa.gov.au> a écrit dans le message de
>>news:41b3ddd9$0$29529$c30e37c6_at_ken-reader.news.telstra.net...
>>
>>>Hi,
>>>
>>>What is the difference between NLS_DATABASE_PARAMETERS
>>>and NLS_INSTANCE_PARAMETERS?
>>>
>>>Craig.
>>>-- 
>>
>>"NLS_DATABASE_PARAMETERS lists permanent NLS parameters of the database."
>>That is set at the database creation.
>>"NLS_INSTANCE_PARAMETERS lists NLS parameters of the instance."
>>That is set by the init.ora or spfile (or alter system command for a few

>
> of them).
>
>>Regards
>>Michel Cadot
>>

>
> Hi Michel,
>
> Which settings are used by sysdate?
>
> Craig.
>
>

I think this might be a followup to a previous posting about date values mysteriously being off by 12 hours, some of the time.

You must also consider NLS parameters set at the session level.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch3.htm#49267

-- 
Mark Bole
http://www.bincomputing.com
Received on Mon Dec 06 2004 - 20:01:15 CST

Original text of this message

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