RE: Column Title

From: <BINAY.KUMAR_at_ponl.com>
Date: Fri, 07 Dec 2001 05:12:27 -0800
Message-ID: <F001.003D753F.20011207045519@fatcity.com>

Thanks Alex, It worked fine. Still wondering how come that this problem is only there in one of the 16 Oracle database instance ?

-Binay

Binay,

It is a bug related to cursor_sharing=force. Try alter session set cursor_sharing=exact.

Alex.

-----Original Message-----

Sent: Wednesday, December 05, 2001 9:25 AM To: Multiple recipients of list ORACLE-L

Hello DBA-Gurus,

Executing the same query on 2 databases, but getting different output- the column title. In all the databases its limited to the value of the row except
in one database we've. All the databases are of 8.1.7.2 running on IBM/unix server.

Database- A

select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;

SUB
---

LET Database-B

select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;

SUBSTR('LETMEBABYONEMORET

LET See the output of Database-B - that's the difference from the others.It seems
that its a database specific problem- we tried with all SQLPLUS versions, both
Unix and Windows and objerved the same.

Eager to know what makes the difference - all your comments are welcome.

Thanks

-Binay

The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through our network.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: BINAY.KUMAR_at_ponl.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

We reserve the right to monitor all e-mail communications through our network.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: BINAY.KUMAR_at_ponl.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message