Home » SQL & PL/SQL » Client Tools » help required on sqlplus settings
help required on sqlplus settings [message #232005] Thu, 19 April 2007 01:21 Go to next message
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 #232009 is a reply to message #232005] Thu, 19 April 2007 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't have the same version, don't you?

Regards
Michel
Re: help required on sqlplus settings [message #232010 is a reply to message #232005] Thu, 19 April 2007 01:35 Go to previous messageGo to next message
kssarayu
Messages: 18
Registered: March 2007
Junior Member
Its same version. sorry. i did not mention that.
its 9.2.0.8 -Enterprised edition.

Thanks
Sarayu
Re: help required on sqlplus settings [message #232012 is a reply to message #232010] Thu, 19 April 2007 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the client?
Both local or remote access? Or one local and the other remote?
Same login.sql/glogin.sql?
NLS parameters same ones? Query nls_database_parameters and nls_session_parameters?

Regards
Michel
Re: help required on sqlplus settings [message #232015 is a reply to message #232005] Thu, 19 April 2007 01:43 Go to previous messageGo to next message
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
Re: help required on sqlplus settings [message #232020 is a reply to message #232015] Thu, 19 April 2007 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, there are these files, at least in $ORACLE_HOME/...
Execute a find on it.

Regards
Michel

Re: help required on sqlplus settings [message #232021 is a reply to message #232005] Thu, 19 April 2007 02:00 Go to previous messageGo to next message
kssarayu
Messages: 18
Registered: March 2007
Junior Member
i verified and found that there are no glogin.sql and login.sql files on these machines.

thanks
sarayu
Re: help required on sqlplus settings [message #232043 is a reply to message #232021] Thu, 19 April 2007 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Very curious, should be in $ORACLE_HOME/sqlplus/admin.
If all are the same, I don't see why you have a distinct result.
Most of the cases is distinct SQL*Plus versions.

Regards
Michel

Re: help required on sqlplus settings [message #232253 is a reply to message #232005] Thu, 19 April 2007 23:10 Go to previous messageGo to next message
kssarayu
Messages: 18
Registered: March 2007
Junior Member
Thank Michael for your assistance.

I posted the same question in asktom and found the solution.
Its because of "CURSOR_SHARING".


http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:228614500346120336

Re: help required on sqlplus settings [message #232262 is a reply to message #232253] Thu, 19 April 2007 23:39 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for posting here the solution you found. Thumbs Up

Regards
Michel
Previous Topic: Spool SQL*PLUS Output - No Whitespace
Next Topic: TOAD 7.5
Goto Forum:
  


Current Time: Fri Dec 02 12:21:41 CST 2016

Total time taken to generate the page: 0.12620 seconds