Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Control for "Isolation level" at SELECT statement level

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

From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Sun, 17 Aug 2003 22:36:35 GMT
Message-ID: <TrT%a.141676$Oz4.32297@rwcrnsc54>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US