Re: connect by clause

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 13 Jul 2003 23:03:15 -0700
Message-ID: <1a75df45.0307132203.40b3f18f@posting.google.com>

shankar72 <member33008_at_dbforums.com> wrote

> tried all the things suggested in your mail

How do the explain plans (Test/Dev vs.Prod) look like?

BTW, I find it hard to accept that the _exact_ same data using the _exact_ same SQL on two different Oracle databases, can give different results.

I will take the SQL, simplify it to its most basic form and run it on both and compare the results. And then gradually increase the complexity until the difference is hit.

FWIW, I think it must be data. Maybe something as obscure in the way NULLS or space are used.. or what character set is selected in the init.ora file.

--
Billy

Received on Mon Jul 14 2003 - 01:03:15 CDT