Re: How to get the generated key from insert with Oracle

[Larry Meadors]

I think this would be the preferred SQL for that:

select ids.currval from dual

...where ids is your sequence's name.

Larry