thtsang_yh_at_yahoo.com.hk wrote:
> I am maintaining an old system. One stupid SQL statement used an "IN
> list" to select some records and relies on the output order, but it
> does not use an order by clause! It worked with the RBO. However, if
> CBO is used, the order is different and cause program error. I don't
> want to modify the source code.
>
> OS: Redhat Enterprise 4.0
> Oracle: 10g Release 2, 32 bit
Modify the source code.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Tue Sep 19 2006 - 10:03:12 CDT
