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

From: Marquez, Chris <CMarquez_at_aarp.org>
Date: Tue, 1 Feb 2005 17:19:01 -0500
Message-ID: <7E412C164E6ECB468834A39F31E6E0D40666DBE6@mbs06dc.na.aarp.int>

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

Received on Tue Feb 01 2005 - 17:22:49 CST