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

Hillel Eilat 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.

No. But I am fascinated on how one session can allow dirty reads to other sessions that don't.

Seems like a capability searching for a reason to exist. And for which I can find none.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)