Retrieving last created sequence index
Posted on 2002-05-29
Let's say I have a table with 2 columns,
dogindex auto-generating sequence number
If I insert a row into the table, how do I retrieve the last created index? I am not looking for the following answer:
select max(dogindex) from dogtable
Rather, I'm looking for an Oracle equivalent of MS SQL Server's @@Identity system variable that will return the last created index.