Pascal01 needs the first row and the last row as inserted in the table. I know there is no first and last row concept in Oracle. He needs the way data are entered in the table first callled first data and the last as last data as it is available at a point in time. Guys test for yourself rownum works as i said:

Code:
SQL>  create table san (i integer);

Table created.

SQL> insert into san values(1);

1 row created.

SQL> insert into san values(3);

1 row created.

SQL> insert into san values(5);

1 row created.

SQL> insert into san values(6);

1 row created.

SQL> commit;

Commit complete.

SQL> delete from san where i=1;

1 row deleted.

SQL> select * from san;

         I
----------
         3
         5
         6

SQL> select * from san where rownum=1;

         I
----------
         3

SQL> rollback;

Rollback complete.

SQL> select * from san where rownum=1;

         I
----------
         1

SQL> select * from san;

         I
----------
         1
         3
         5
         6

SQL>