Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?

Maybe I don’t understand the question, but wouldn’t this do it? (you must know what you want back)

INSERT INTO some_table (...)
VALUES (...)
RETURNING some_column_a, some_column_b, some_column_c,  ...  INTO :out_a, :out_b, :out_c, ...

@Vincent returning bulk collect into for multi-row insert works only in conjunction with forall (in another words if you insert from collection you can retrieve “results” into another)

Leave a Comment