Re: How to get the last insert id

From: <vitalisman_at_gmail.com>
Date: Fri, 07 Sep 2007 08:47:28 -0700
Message-ID: <1189180048.921543.314940@k79g2000hse.googlegroups.com>

On Sep 7, 5:33 pm, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
> Hello,
>
> does anyone know how to get the id of the last inserted dataset in
> Oracle?
>
> SQL Server does have Scope_Idendity, MySQL has LastInsertID
>
> Thanks,
> Norbert

Please explain what is "the id of the last inserted dataset" (with an example) in your Oracle database. Received on Fri Sep 07 2007 - 10:47:28 CDT

This message: [ Message body ]
Next message: Mark D Powell: "Re: Problem with fetching LONGs and LONG RAWs (ORA-01062)"
Previous message: Ken Denny: "Re: A question about performing UPDATE and multiple tables"
In reply to: Norbert Pürringer: "How to get the last insert id"
Next in thread: fitzjarrell_at_cox.net: "Re: How to get the last insert id"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US