[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
