Different default 8i/9i column lengths when selecting pseudo columns...
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Feb 2005 17:19:01 -0500
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"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
