| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Column Title
Binay,
It is a bug related to cursor_sharing=force. Try alter session set cursor_sharing=exact.
Alex.
-----Original Message-----
From: BINAY.KUMAR_at_ponl.com [mailto:BINAY.KUMAR_at_ponl.com]
Sent: Wednesday, December 05, 2001 9:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Column Title
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
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 Liststo: 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). Received on Thu Dec 06 2001 - 18:00:52 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |