RE: Different default 8i/9i column lengths when selecting pseudo columns...
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>, <thomas.mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Feb 2005 10:36:20 -0500
Lex
>>not relying on...version-specific tool behavior=20
>>explicitly telling the tool how you want to see your results?
I would agree 100%, but the script owner asked me "look into" the Oracle
difference.
So let just stop this logical thought right there. :O|
>>- Change CURSOR_SHARING to EXACT.
Yup...had this issue with another database...but not the issue this
time.
Tom
>>I just tried this in my 817 and 9203=20
>>queries return a row like your 817 example - that is 5 chars in
length.
>>Maybe you have a glogin.sql script...
The glogin.sql was the first place I looked...using the default 9i
glogin.sql script?
AND I competed the difference between my 8i and 9i glogin.sql scripts
only 4 diff's and I set or tried setting the equal...no help!?
Thanks for the test...I'm going to test on a different set of servers?
Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"
-----Original Message-----
From: Lex de Haan [mailto:lex.de.haan@xxxxxxxxxxxxxx]=20
Sent: Wednesday, February 02, 2005 8:56 AM
To: thomas.mercadante@xxxxxxxxxxxxxxxxx; Marquez, Chris;
oracle-l@xxxxxxxxxxxxx
Subject: RE: Different default 8i/9i column lengths when selecting
pseudo columns...
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,
=20
Lex.
=20
----------------------------------------------------------------
Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
----------------------------------------------------------------
=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mercadante, Thomas F
Sent: Wednesday, February 02, 2005 14:40
To: 'CMarquez@xxxxxxxx'; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxx]
Sent: Tuesday, February 01, 2005 5:19 PM
To: oracle-l@xxxxxxxxxxxxx
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...
=3D20
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D20
8.1.7 SQL*Plus=3D20 =
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D
SQL> select 'xxxxx' from dual;
'XXXX
-----
xxxxx
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D20
9.2.0 SQL*Plus=3D20 =
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D20
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
