Re: get sequence number for a row just inserted?

From: DA Morgan <>
Date: Thu, 11 Dec 2008 17:17:51 -0800
Message-ID: <> 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

The other the RETURNING clause
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Dec 11 2008 - 19:17:51 CST

Original text of this message