sql - Get the id of the last inserted row ORACLE/PHP -

how last id using php

similar mysqli_insert_id($conexao)

many oracle programs use database objects called sequences generate unique ids. if know sequence used id in table inserted into,

select sequencename.currval dual; 

immediately after insert, in same database connection, , you'll id number.

select max(id) , similar constructs work fine long only, ever, have 1 connection database: meaning don't work. they're not thread-safe. they're more expensive currval.