how to get the last inserted id

terpe · **Posted:** Tue Jan 19, 2010 2:24 pm

Hi,

I try many methods to get the last inserted id with no luck. Is there any simple vay to get this id? The cursor must have attribute for returnig the insert id but i can't found.

hda · **Posted:** Tue Jan 19, 2010 4:32 pm

Code:

select max(id) from your_obj_name;

above query will return last inserted id.
if you want latest modifies id then you can check on
write_date and create_date fields.

terpe · **Posted:** Wed Jan 20, 2010 11:29 am

thanks for reply!

i tried with luck this:

Code:

last_insert_id = cr.lastrowid

cr.lastrowid gets the oid