Retrieve last row inserted into table in Oracle

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database design and architecture Can I download DBCA for Oracle Express Edition? How to recreate an Oracle index in a new schema with the CREATE command Using Oracle Universal Installer to install Oracle with Pro*C Defining Oracle database repository vs. information repository Can I create multiple schemas in Oracle for one user? ORA-12514 error when connecting to the Oracle database through Toad Solving the ORA-00904 error: invalid identifier in Oracle How to tune SQL UPDATE statements for an Oracle 10g upgrade Will queries run slower in a smaller Oracle buffer cache? Using a database link to connect two Oracle apps instances Oracle database design and architecture Can I download DBCA for Oracle Express Edition? How to recreate an Oracle index in a new schema with the CREATE command Using Oracle Universal Installer to install Oracle with Pro*C Defining Oracle database repository vs. information repository Can I create multiple schemas in Oracle for one user? ORA-12514 error when connecting to the Oracle database through Toad Solving the ORA-00904 error: invalid identifier in Oracle How to tune SQL UPDATE statements for an Oracle 10g upgrade Will queries run slower in a smaller Oracle buffer cache? Using a database link to connect two Oracle apps instances

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary E. F. Codd  (SearchOracle.com) extent  (SearchOracle.com) flexfield  (SearchOracle.com) foreign key  (SearchOracle.com) multidimensional database  (SearchOracle.com) object-oriented database management system  (SearchOracle.com) quad tree  (SearchOracle.com) relational online analytical processing  (SearchOracle.com) row  (SearchOracle.com) splay tree  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

In relational database theory, there is no concept of the "first" or "last" row of a table. And using ROWNUM wouldn't help here either as you are not guaranteed any specific ordering in the table.

Most people who have this requirement add a column to the table of DATE datatype (or maybe TIMESTAMP) and then create a trigger to update this column's value with the current date and time on INSERT. If you can't modify this table's structure, then you can create another table consisting of this table's primary key column(s) and the column to show when that PK value was inserted into the original table. Then create a trigger to populate your newly created table when a row is inserted into the original table.