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@po
nl.com To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
