Results 1 to 2 of 2

Thread: A query that returns las inserted rows

  1. #1
    Nauj Guest

    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

  2. #2
    Guest

    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
  •