Home » SQL & PL/SQL » SQL & PL/SQL » LAST_INSERT_ID() ?
LAST_INSERT_ID() ? [message #253064] Sun, 22 July 2007 01:59 Go to next message
JOHNDARREN01
Messages: 7
Registered: July 2007
Location: Philippines
Junior Member
does anyone know the equivalent of mysql function LAST_INSERT_ID() in PL/SQL?

i can't seem to find any document about this.

Re: LAST_INSERT_ID() ? [message #253070 is a reply to message #253064] Sun, 22 July 2007 02:27 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Look at sequences.

SELECT <sequencename>.CURRVAL from DUAL;


HTH.
Michael
Re: LAST_INSERT_ID() ? [message #253072 is a reply to message #253064] Sun, 22 July 2007 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is none.
You have to manager IDs in another way in Oracle.

Regards
Michel
Re: LAST_INSERT_ID() ? [message #253081 is a reply to message #253064] Sun, 22 July 2007 03:48 Go to previous message
JOHNDARREN01
Messages: 7
Registered: July 2007
Location: Philippines
Junior Member
thanks for the reply. i got it.
Previous Topic: How to use prepare statment?
Next Topic: how i can get the day from date
Goto Forum:
  


Current Time: Mon Dec 05 21:30:37 CST 2016

Total time taken to generate the page: 0.10686 seconds