Re: SELECT

From: Steve <alan_bo_at_hotmail.com>
Date: 21 Sep 2001 07:01:45 -0700
Message-ID: <15c65e2b.0109210601.651ad1a7@posting.google.com>

There is absolutely no last or first row in Oracle. You have the responsibilty to define it by certain kind of way, for example: add another column "timestamp" or other staffs in the table to distinguish the order of rows. Otherwise, the output of the query is just "random" order of the rows.

Rownum is coming out after the row(s) returned, so the same rownum may correspond to different row each time in the output of a query.

Thanks Received on Fri Sep 21 2001 - 09:01:45 CDT