Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Weird query results

Weird query results

From: Ricardo Melo <ricardo_melo_at_yahoo.com>
Date: Sat, 04 Mar 2000 16:12:45 GMT
Message-ID: <1Caw4.18776$e53.733429@news20.bellglobal.com> 





I'm using Oracle 8i.



I'm having problems with a query with multiple tables and a left join. If a
tell the oracle to use my where clause as is using the hint /*+ordered*/ it
gives me a complete different result than if I don't specify the hint.  Why
would oracle return 2 different results ?



Received on Sat Mar 04 2000 - 10:12:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US