Re: get sequence number for a row just inserted?

mh_at_pixar.com wrote:
> What's the most canonical way get the autoincremented sequence number of a
> row I just inserted?

Two ways: One is to use CURRVAL
http://www.psoug.org/reference/sequences.html

The other the RETURNING clause

http://www.psoug.org/reference/insert.html
http://www.psoug.org/reference/update.html
http://www.psoug.org/reference/delete.html

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org