RE: output of a select statement

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 25 Mar 2014 11:53:04 -0400
Message-ID: <120f01cf4842$4ff34c60$efd9e520$_at_rsiz.com>

That certainly *looks* like a column format difference - but you've denied differences in sqlplus settings.

I'd look for a glogin.sql or login.sql nonetheless, and I would add a column format setting something like

column "'a'" format a3 hea duh

to see whether that changes the display on both databases. IF it does, I would redouble my efforts to find where the column 'a' format was being left the default on one database and being set on the other.

You have an interesting email address.

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ORACLE-L
Sent: Tuesday, March 25, 2014 9:31 AM
To: oracle-l_at_freelists.org
Subject: output of a select statement

Hi Group,

I have two DBs10.2.0.4 running on Solaris 10.

And the output on these two databases are totally different from sqlplus:

Select 'a' from dual;

Output a:

'

-
a

output b:

'A'

---

a

I compare the system parameters and the setting for sqlplus, no difference found.

I 'm wondering how dose the difference come out?

Rgds

David--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 25 2014 - 16:53:04 CET