dgoulet_at_vicr.com wrote:
>
> Hey folks,
>
> Now I've seen some odd results form queries in the past, but I'll be d*mned
> is I can figure this one out. It defies logic.
>
> I've two queries that each return 50 rows from the database & the rows are
> the same is each case (stubby pencil check), but of the three columns returned
> the last two reverse. I'm including the SQL, a sample result set, and the view
> definitions that are being used. If you can figure it out, please let me know.
> I'm asking OTS as well.
>
> Dick Goulet
>
Waow, that's really weird. You say that what you are querying are VIEWS.
Could you post the view text as well? I suspect that's where weirdness
comes from. If they happen to be UNIONs with swapped columns in one
segment, the fact that the RTRIM() changes the execution plan (probably)
might hit other sections of the data.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Mar 28 2002 - 14:23:22 CST
