Returning Identity from the Database

Sometimes we need to return the next generated number of the identity column.

We can use simple Pl/SQl to achieve this:

SELECT @@IDENTITY FROM tblPerson

This will return the next generated value of the identity column of the tblPerson table.