sagiegurari / simple-oracledb

Extend capabilities of oracledb with simplified API for quicker development.
Apache License 2.0
36 stars 4 forks source link

is there any possibility to quickly gets row id that inserted newly to table ? #12

Closed behroozshafiabadi closed 8 years ago

behroozshafiabadi commented 8 years ago

hi @sagiegurari i have type of inserts that i need get back row id that newly inserted...is there any possible way Except select after insert, that get backs new rows id ?

sagiegurari commented 8 years ago

not in the api, but you can do it via pl/sql. here is an example: http://stackoverflow.com/questions/5558979/inserting-into-oracle-and-retrieving-the-generated-sequence-id