FYI:

> 4. Oracle defines a SQL extention that return specific values that
> apparently only works for singleton inserts. (Does anyone know
> this for sure?)

Oracle:

returning_clause

The returning clause retrieves the rows affected by a DML statement. You can
specify this clause for tables and materialized views and for views with a
single base table.

When operating on a single row, a DML statement with a returning_clause can
retrieve column expressions using the affected row, rowid, and REFs to the
affected row and store them in host variables or PL/SQL variables.

When operating on multiple rows, a DML statement with the returning_clause
stores values from expressions, rowids, and REFs involving the affected rows
in bind arrays.



With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com