| help required on sqlplus settings [message #232005] |
Thu, 19 April 2007 01:21  |
kssarayu
Messages: 18
Registered: March 2007
|
Junior Member |
|
|
hi all,
we have two databases. These two are supposed to be having similar settings.
In database 1:
SQL> select ',' from dual;
'
-
,
In second database database 2:
SQL> select ',' from dual;
','
--------------------------------
,
May i know what kind of settings in sqlplus/oracle would change this behaviour to display same sql statement. One db shows only 1 character and second database is taking more than 30 characters.
Thanks in advance.
Sarayu
|
|
|
|
|
|
|
|
|
|
| Re: help required on sqlplus settings [message #232015 is a reply to message #232005] |
Thu, 19 April 2007 01:43  |
kssarayu
Messages: 18
Registered: March 2007
|
Junior Member |
|
|
there are no login.sql/glogin.sql
values in nls_database_parameters and nls_session_parameters are exactly same.
I logged into the database machine directly and trying to execute these sqls there
Thanks again for your quick assistance.
Sarayu
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
