first/last row in a table

[slimdave]

use rownum=1 in where clause will get you the first and to get the last ???
there are ways to do..........Find it

Wrong, I'm afraid. As TS says there is no concept of "first" or "last" row in a relation.

Pascal, what you need is a column that defines for you which row is "first" or "last" ... something like "insert_timestamp", so that you could ...

select * from
(
select * from my_table order by insert_timestamp
)
where rownum = 1