Home » SQL & PL/SQL » SQL & PL/SQL » Re: Retrieving records N to N+10 !! Perplexed
Re: Retrieving records N to N+10 !! Perplexed [message #22166] Thu, 26 September 2002 10:37
Amit Chauhan
Messages: 74
Registered: July 1999
Member
Hi,
Thanks for the reply. Thats not the case, as you can see in my previous post, I have posted both the results, with and without order by. And they are different. This means its not inserted in the natural order.

Am not sure whats happening here, because I knew Oracle assigns rownum before ordering.

Any more suggestions please.
Thanks
Amit

Report message to a moderator

Previous Topic: Re: Retrieving records N to N+10 !! Perplexed
Next Topic: rollback to savepoint in a package
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 02:55:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.