RE: Different default 8i/9i column lengths when selecting pseudo columns...

one more idea comes to mind: are you using cursor sharing, by any chance?
see Metalink, bug 2092801, for an issue that might hit you ...
the workarounds listed in that bug are:
- Use the FORMAT command to set explicit column widths.
- Change CURSOR_SHARING to EXACT.
- Flush the shared pool.

cheers,
 
Lex.
 
----------------------------------------------------------------
Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
----------------------------------------------------------------
 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mercadante, Thomas F
Sent: Wednesday, February 02, 2005 14:40
To: 'CMarquez@xxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: RE: Different default 8i/9i column lengths when selecting pseudo
columns...

Chris,

I just tried this in my 817 and 9203 databases and get different results
than you.  Both my queries return a row like your 817 example - that is 5
chars in length.

Maybe you have a glogin.sql script that is setting a column length for you
in 92 but not in 817?

Tom


-----Original Message-----
From: Marquez, Chris [mailto:CMarquez@xxxxxxxx]
Sent: Tuesday, February 01, 2005 5:19 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Different default 8i/9i column lengths when selecting pseudo
columns...


Different default 8i/9i column lengths when selecting pseudo columns...

This is the issue...
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
8.1.7 SQL*Plus=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
SQL> select 'xxxxx' from dual;
'XXXX
-----
xxxxx

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
9.2.0 SQL*Plus=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
SQL> select 'xxxxx' from dual;

'XXXXX'
--------------------------------
xxxxx

How do I change the default behavior in 9i to "stop" the column at the
end of the last character of the pseudo columns (like 8i default)?

Thanks

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l



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

Other related posts: