RE: output of a select statement(B

From: Mark W. Farnham(B <mwf_at_rsiz.com>
Date: Thu, 27 Mar 2014 07:01:01 -0400
Message-ID: <046c01cf49ab$d831a080$8894e180$_at_rsiz.com>

Yes. JL's detection that the formatting difference was due to different default column formatting because of the difference between the literal length and the length of one of the choices for a bind variable in support of the changed setting for cursor sharing was spot on and a great pick up.

It also served as a great reminder that the mechanism of cursor sharing is factoring literals into a usefully spread possible set of bind variable lengths.

IF you need a different column formatting, injecting (either in (g)login.sql or a script setting an individual sqlplus sessions depending on the scope you need) a statement similar to the one I suggested you test containing the type and heading you actually want should keep it from varying and give you an opportunity to supply the logical name for the column heading in place of a value based column name.

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Yu
Sent: Wednesday, March 26, 2014 10:31 PM To: mwf_at_rsiz.com
Cc: <oracle-l_at_freelists.org>
Subject: Re: output of a select statement

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

$B:_(B 2014-3-26$B!$2<8a(B11:38$B!$(B"Mark W. Farnham" <mwf_at_rsiz.com> $B<LF;!'(B

> 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
>
> $B:_(B 2014-3-26$B!$>e8a(B12:00$B!$(BHans Forbrich <fuzzy.graybeard_at_gmail.com> $B<LF;!'(B
>
>> 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-l


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 27 2014 - 12:01:01 CET