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: <Jared.Still_at_radisys.com>
Date: Wed, 05 Dec 2001 11:08:53 -0800
Message-ID: <F001.003D5F4D.20011205103024@fatcity.com>

Binay,

Try typing the command 'CLEAR COLUMNS' before doing the select.

It may be something in login.sql or glogin.sql that is creating the difference.

Jared

PS. You seem to be hung up on 'The Captain and Tenille'. Therapy is available.

                                                                                       
                             
                    BINAY.KUMAR_at_po                                                     
                             
                    nl.com               To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    Sent by:             cc:                                           
                             
                    root_at_fatcity.c       Subject:     Column Title                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    12/05/01 09:25                                                     
                             
                    AM                                                                 
                             
                    Please respond                                                     
                             
                    to 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).

--

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

Author:
  INET: Jared.Still_at_radisys.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 Wed Dec 05 2001 - 13:08:53 CST

Original text of this message

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