Re: Sort Order in Nested query
From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Fri, 1 Feb 2013 10:12:56 +0000
Message-ID: <CAOuMUT5WJBNZCtQhmpcyKvQrceySn=oxHn8m7eh2u+9Qc+YeZg_at_mail.gmail.com>
Hi Gints,
Yes query rewrite is exactly what I'm afraid will happen. Hadn't thought of that hint but as you say that can't be relied on for certain. I'll remove the sequence from the query to work around the problem.
Date: Fri, 1 Feb 2013 10:12:56 +0000
Message-ID: <CAOuMUT5WJBNZCtQhmpcyKvQrceySn=oxHn8m7eh2u+9Qc+YeZg_at_mail.gmail.com>
Hi Gints,
Yes query rewrite is exactly what I'm afraid will happen. Hadn't thought of that hint but as you say that can't be relied on for certain. I'll remove the sequence from the query to work around the problem.
Thanks,
Fergal
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 01 2013 - 11:12:56 CET