Re: Different default 8i/9i column lengths when selecting pseudo columns...
- From: Thomas Day <tomday2@xxxxxxxxx>
- To: CMarquez@xxxxxxxx
- Date: Thu, 3 Feb 2005 10:48:34 -0500
Hi guy. My results, obviously on windows. Try a describe on dual and
see if someone has renamed the column. I haven't been able to
reproduce your results.
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
5 rows selected.
SQL> select 'xxxxx' from dual;
'XXXX
-----
xxxxx
1 row selected.
SQL> col xxxxx format a20
SQL> select 'xxxxx' xxxxx from dual;
XXXXX
--------------------
xxxxx
SQL> desc dual
Name
-----------------------------------
DUMMY
SQL> col dummy format a20
SQL> select 'xxxxx' from dual;
'XXXX
-----
xxxxx
1 row selected.
SQL> select 'xxxxx' dummy from dual;
DUMMY
--------------------
xxxxx
1 row selected.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
