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

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Wed, 2 Feb 2005 14:55:30 +0100
Message-Id: <20050202135536.A148D47E4CD@ha-smtp2.tiscali.nl>

one more idea comes to mind: are you using cursor sharing, by any chance? see Metalink, bug 2092801, for an issue that might hit you ... the workarounds listed in that bug are:

- Use the FORMAT command to set explicit column widths.
- Change CURSOR_SHARING to EXACT.
- Flush the shared pool.

cheers,  

Lex.  

---

Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html

---

 

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
Sent: Wednesday, February 02, 2005 14:40 To: 'CMarquez_at_aarp.org'; oracle-l_at_freelists.org Subject: RE: Different default 8i/9i column lengths when selecting pseudo columns...

Chris,

I just tried this in my 817 and 9203 databases and get different results than you. Both my queries return a row like your 817 example - that is 5 chars in length.

Maybe you have a glogin.sql script that is setting a column length for you in 92 but not in 817?

Tom

-----Original Message-----
From: Marquez, Chris [mailto:CMarquez_at_aarp.org] Sent: Tuesday, February 01, 2005 5:19 PM 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

---

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
--
http://www.freelists.org/webpage/oracle-l



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

Received on Wed Feb 02 2005 - 09:00:04 CST