Re: connect by clause

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 10 Jul 2003 22:27:41 -0700
Message-ID: <1a75df45.0307102127.1df6b0f5@posting.google.com>

shankar72 <member33008_at_dbforums.com> wrote

> i have written this query on test database works fine but when we
> transfered both tables and the query to production we are getting two
> different results

Scope. You are not using absolute path table names. How sure are you that the query is hitting the exact same two tables that was imported from Test? A simple select count(*) on the tables will help.

Have you debugged the query on Prod? Pull it apart. Change the projection to a count(*) and do each SQL of that query in isolation to test its results. Compare Prod with Test.

I do not think it has anything to do with the minor Oracle version difference between Prod and Test.

--
Billy

Received on Fri Jul 11 2003 - 00:27:41 CDT