Re: output of a select statement
Date: Thu, 27 Mar 2014 10:31:07 +0800
Message-Id: <B653F02C-7136-4ECA-9F30-E3D001EDFC87_at_gmail.com>
Thanks Mark,
I use the same sqlplus,actually,the databases running on the same server with the same oracle home .
You must have seen Jonathan's comment on this, that's explain everything.
Rgds
David
在 2014-3-26，下午11:38，"Mark W. Farnham" <mwf_at_rsiz.com> 写道：
> Dear Mr. Fishy,
>
> Did you in fact find a login.sql or glogin.sql difference, and did
>
> column "'a'" format a3 hea duh
>
> in your sqlplus session before the query in fact demonstrate that it was a
> column formatting problem?
>
> (And I'm not sure I understand your mention of any cursor sharing bugs in
> this context, or what was strange about it.)
>
> r,
> mwf
>
> -----Original Message-----
> From: ORACLE-L [mailto:mr.fishyu_at_gmail.com]
> Sent: Wednesday, March 26, 2014 9:27 AM
> To: fuzzy.graybeard_at_gmail.com; mwf_at_rsiz.com
> Cc: oracle-l_at_freelists.org
> Subject: Re: output of a select statement
>
> Thank you for your reply,there's another issue within
> 10.2.0.3,cursor_sharing set to similar or force will trigger the bug.after
> setting to exact,this issue fixed too.a bit strange :)
>
> Rgds
>
> David
>
> 在 2014-3-26，上午12:00，Hans Forbrich <fuzzy.graybeard_at_gmail.com> 写道：
>
>> On 25/03/2014 7:30 AM, ORACLE-L wrote: >>> Hi Group, >>> >>> I have two DBs10.2.0.4 running on Solaris 10. >>> >>> And the output on these two databases are totally different from sqlplus: >> Are these run from the same client? Are they from a client on each
> machine or perhaps from a separate client? What happens if you use the same
> client to access each DB?
>> >> Two things I would check to start >> >> 1) Any login.sql/glogin.sql >> 2) Language/Territory related settings at the client and on the Solaris
> machines.
>> >> /Hans >> -- >> http://www.freelists.org/webpage/oracle-l
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 27 2014 - 03:31:07 CET