To return a value from a DML command (for example, a newly generated ID from an INSERT), you can use a PL/SQL block with the RETURNING INTO clause. This requires configuring an output bind variable.
CedarDB pushed to the limit in improbable gaming experiment The world has moved on from making Doom run on increasingly ...
SQL-Database-Applications-Portfolio SQL projects for concert, parking, & flight tracking databases. Features normalized schemas, stored procedures, DML, & advanced queries (joins, aggregates).