Re: Sort Order in Nested query
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 31 Jan 2013 19:11:45 +0000
Message-ID: <CABe10sZ_EAwf0hTDYyaWA3rjRAwy7KscUzjjpUMRtt=9PnXi_w_at_mail.gmail.com>
I'm confused as to the purpose of a sequence.nextval in the select. The query will return different results each time it is run surely. You could probably store a hi gh value in a 1 row table and use the connect by prior trick, but it seems like we're missing important details.
Date: Thu, 31 Jan 2013 19:11:45 +0000
Message-ID: <CABe10sZ_EAwf0hTDYyaWA3rjRAwy7KscUzjjpUMRtt=9PnXi_w_at_mail.gmail.com>
I'm confused as to the purpose of a sequence.nextval in the select. The query will return different results each time it is run surely. You could probably store a hi gh value in a 1 row table and use the connect by prior trick, but it seems like we're missing important details.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 31 2013 - 20:11:45 CET