From: Pit Capitain <pit@...>
Date: 2004-09-01T04:14:51+09:00
Subject: Re: [Ruby-DBI-devel] Common Last Index Method

Dan Janowski schrieb:

> Postgres returns an OID as a result of INSERT statements. It is in-band 
> with the execution. It may be the only DB that does this and is the most 
> compelling case. Support for auto-increment is easy as you illustrate. 
> As for Oracle and other DBs that require the pre-fetch of sequences for 
> that kind of tracking, it is probably better to leave get_last_rowid as 
> raise "unimplemented".

Since many, many years, in Oracle-SQL you can do

   INSERT INTO ... VALUES ( ... ) RETURNING <columns> INTO <output-vars>

This even works for INSERTs that create more than one row.

Regards,
Pit