Re: Oracle transaction question

Thanks for the info. A followup...

If the select/delete transaction is in serializable mode, does the insert also have to be in serializable mode also?

Thanks

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:41b0bf14$0$28753$626a14ce_at_news.free.fr...
>
> "Bill" <bli01_at_yahoo.com> a écrit dans le message de
news:C02sd.16$%V3.9_at_fe04.lga...
> > Hi all,
> > Can someone help with this question?
> >
> > In a program, 2 SQL statements are executed in the same transaction.
The
> > first is a SELECT statement based on a status column in a table equals
to
> > "X", e.g. SELECT * FROM TABLE1 WHERE STATUS='X'. The second is a DELETE
> > statement, deleting all rows with STATUS='X', e.g. DELETE FROM TABLE1
WHERE
> > STATUS='X'. Both are in one transaction.
> >
> > During the execution of this transaction, after the SELECT but before
the
> > DELETE, another program inserts another row into TABLE1 with STATUS='X'.
> > Will the newly inserted row also be deleted?
> >
> > Thanks,
> > Bill
> >
> >
>
> If the insert is not commited, no.
> If the insert is commited and you are in the default transactional mode,
yes.
> If the insert is commited and you are in serializable mode, no.
>
> Regards
> Michel Cadot
>
>
Received on Fri Dec 03 2004 - 14:09:01 CST