All information shown below are coming from single source i.e init.ora
file ,only the method of getting info is different.
Regds,
Vaishali.
-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x92840336.[Email address protected]
Sent: Monday, October 08, 2007 4:25 PM
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
----------------------------------------------------------------------
DISCLAIMER
This email and any files transmitted with it are confidential and are solely for the use of the individual or entity to which it is addressed. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of the company shall be understood to be neither given nor endorsed by NIIT Ltd. or NIIT Technologies Ltd. Any information contained in this email, when addressed to Clients is subject to the terms and conditions in governing client contract.
Oracle LazyDBA home page