select .. for update skip locked

From: Nilo Segura <nilosegura_at_gmail.com>
Date: Wed, 22 Mar 2006 15:38:29 +0100
Message-ID: <4ce989e0603220638i28663aa0uaa1a9be38c20d1c1@mail.gmail.com>

Hello,

Does anybody know if this "very useful" feature will be "exposed" to us mortals in the next version (11g) ? Anybody using it in "production" ?

It is used internally in some Oracle products and it does actually work but it is "officially" not documented... It is available in other RDBMS systems (DB2, SQL Server) but not on Oracle which I find "odd"...

Thanks!

Nilo Segura
Oracle Support - IT/DEs
CERN - Geneva
Switzerland

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 22 2006 - 08:38:29 CST