使用php在oracle中获取最后插入的id

Question

I have two tables created with this:

CREATE TABLE t1 (id NUMBER GENERATED AS IDENTITY);
CREATE TABLE t2 (id NUMBER GENERATED AS IDENTITY);

Im inserting some data into t1 and then i need to insert the ID generated in that insert into t2.

For example:

"insert into t1 (name, description) values ('asd','dsa')"
**getting that autogenerated ID
"insert into t2 (idFromt1,name) values (idFromt1,'sarasa')"

I saw many examples doing:

"insert into t1 (name, description) values ('asd','dsa') returning ID into inserted_id";

But i cant/dont know how to retrieve that "inserted_id" variable from php to make the second insert.

Answer 1

Either use PDO::lastInsertId or

SELECT MAX(id) FROM table;