RE: dba_jobs nls_env
- From: John Dunn <john.dunn@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 30 Jan 2004 15:38:42 -0000
select nls_env from dba_jobs
When started from a script on Solaris
NLS_ENV
----------------------------------------------------------------------------
----
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$'
NLS_ISO_CURRENC
Y='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MM-YYYY:HH24:MI:SS'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
When started from a VB client session on Windows 2000 :
NLS_LANGUAGE='ENGLISH' NLS_TERRITORY='UNITED KINGDOM' NLS_CURRENCY='#'
NLS_ISO_C
URRENCY='UNITED KINGDOM' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='ENGLISH' NLS_SORT='BINARY'
NLS_DATE_FORMAT is defined as DD-MM-YYYY:HH24:MI:SS in the initSID.ora file
John
-----Original Message-----
From: Jared Still [mailto:jkstill@xxxxxxxxxx]
Sent: 30 January 2004 15:11
To: Oracle-L Freelists
Subject: Re: dba_jobs nls_env
That's interesting, in the absence of 'alter session' I would
expect them to come from the default settings in
nls_session|instance|database_parameters.
What is the evidence that indicates that there is a
difference dependent on client?
Jared
On Fri, 2004-01-30 at 06:55, John Dunn wrote:
> How does dba_jobs decide what it's nls_env values are?.
>
> They seem to vary according to whether I queue the job from a windows
client
> or from unix.
>
> John
>
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
