Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Column Title

RE: Column Title

From: <Alexander.Feinstein_at_mitchell1.com>
Date: Fri, 07 Dec 2001 16:20:29 -0800
Message-ID: <F001.003D8073.20011207160018@fatcity.com>

Binay,

Only this database has
cursor_sharing=force
in init<SID>.ora file.
This is a bug, you can check Metalink.

Alex.

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

From: BINAY.KUMAR_at_ponl.com [mailto:BINAY.KUMAR_at_ponl.com] Sent: Friday, December 07, 2001 4:55 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Column Title

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
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).

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). Received on Fri Dec 07 2001 - 18:20:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US