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

From: Thomas Day <tomday2_at_gmail.com>
Date: Thu, 3 Feb 2005 10:48:34 -0500
Message-ID: <a8c5045905020307483a56c158@mail.gmail.com>

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.

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

Received on Thu Feb 03 2005 - 10:57:55 CST