A query that returns las inserted rows

I'm working with Oracle 8.1, I want to know if it's possible to make a query that return a
recordset containing the last inserted rows or if it's posiible to order the records
of the table in the order in wich were inserted.
I suppose that it's possible using a pseudocolumn or someting similar. ¿any idea?.

Any example, help or advice will be greatly apreciatted.

Nauj

if you have a date column, use Max(dateColumn), or you may be able use max(rowid).

Another possibilty, I believe there is something in Oracle asin SQLSvr where you can do a select * from inserted on a triger to get the row which was just inserted (or updated in an update trigger).


------------
Nauj at 9/26/01 9:14:08 AM

I'm working with Oracle 8.1, I want to know if it's possible to make a query that return a
recordset containing the last inserted rows or if it's posiible to order the records
of the table in the order in wich were inserted.
I suppose that it's possible using a pseudocolumn or someting similar. ¿any idea?.

Any example, help or advice will be greatly apreciatted.

Nauj