Re: Control for "Isolation level" at SELECT statement level

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 17 Aug 2003 16:46:23 +0200
Message-ID: <u85vjv8mi0fqts338m4r8kge8vaut8rv5u@4ax.com>

On Sun, 17 Aug 2003 14:55:54 +0200, "Hillel Eilat" <hillel_at_attunity.co.il> wrote:

>Hi folks.
>
>Some RDBMS products support the following syntax format:
>
>SELECT .... <whatever...> WITH {READCOMMITTED | REPEATABLEREAD | ... |
>SERIALIZABLE}
>
>The WITH clause provides the means for overriding the default isolation
>level (or the one
>specified upon SET TRANSACTION) at a specific SELECT statement.
>
>WITH clause is applicable for INSERT,UPDATE,DELETE as well.
>
>Is there an equvalent to the "WITH" clause in Oracle's SQL?
>
>
>
>Your answers will be appreciated.
>
>
>
>Hillel.
>
>
>
>
>
>
>
>

There isn't. Also you can safely assume when it's not in the manual, it doesn't exist.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Aug 17 2003 - 09:46:23 CDT