-
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
-
A query that returns las inserted rows (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|