Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Control for "Isolation level" at SELECT statement level
Why would you want to with Oracle? What business problem are you trying to
solve?
Jim
"Hillel Eilat" <hillel_at_attunity.co.il> wrote in message
news:bhnqgm$dei$1_at_news2.netvision.net.il...
> 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.
>
>
>
>
>
>
>
>
>
Received on Sun Aug 17 2003 - 17:36:35 CDT