Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Different default 8i/9i column lengths when selecting pseudo columns...
... by not relying on undocumented implicit apparently version-specific tool
behavior
(wow -- that was fun to describe :-)
and explicitly telling the tool how you want to see your results?
cheers,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Marquez, Chris
Sent: Tuesday, February 01, 2005 23:19
To: oracle-l_at_freelists.org
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
=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'
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-lReceived on Wed Feb 02 2005 - 04:14:50 CST