David,

There is an order of preference here. If you change any NLS setting via
alter session commands, then these take preference over everything. If you
connect to a database with environment variables set (like NLS_LANG) then
these will take preference over other settings (excpet as set by alter
session). The next level is as set by NLS_SESSION_PARAMETERS which override
the settings in NLS_INSTANCE_PARAMETERS which override settings in
NLS_DATABASE_PARAMETERS. The value you get will be as set at the lowest
level.

Check out metalink note: 241047.1

HTH
John.

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x92840336.[Email address protected]
Sent: 08 October 2007 11:55
To: LazyDBA Discussion
Subject: difference of parameter between sho parameter command and
nls_database_parameters view....

hello experts,

can you explain the difference..?
please suggest..


SQL> sho parameter %nls%

NAME TYPE VALUE
------------------------------------ ------- -----------
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string DD/MM/YYYY
nls_date_language string FRENCH
nls_dual_currency string
nls_iso_currency string
nls_language string French
nls_numeric_characters string
nls_sort string French
nls_territory string France


SQL> select * from nls_database_parameters;

PARAMETER VALUE
------------------------------ --------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P15
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET WE8ISO8859P15
NLS_RDBMS_VERSION 8.1.7.2.0



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.


Oracle LazyDBA home page