result of "show parameter" for some nls parameters got changed to upper case
Hi,
I have a question regarding the pfile for DB(EBS environment).
The result of "show parameter" for some nls parameters got changed to upper case from 11gR2 like below:
11.1.0.7 and lower:
show parameter
nls_comp binary
nls_language american
nls_sort binary
nls_territory america
11.2.0.2 and higher:
show parameter
nls_comp BINARY
nls_language AMERICAN
nls_sort BINARY
nls_territory AMERICA
*Regardless of DB version, it always returns the value as upper case for standalone DB(Not EBS environment).
but depends on the DB version, the result of "show parameter" are different as mentioned above.
We have a program which checks the result of "show parameter" and it distinguishes between upper- and lower-case,