Re: Sort Order in Nested query

From: Niall Litchfield <>
Date: Thu, 31 Jan 2013 19:11:45 +0000
Message-ID: <>

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.
Received on Thu Jan 31 2013 - 20:11:45 CET

Original text of this message