Re: Commit select-statement ?

Hi Melanie,

There isn't any reason to commit select statements in oracle at all. You only waste time and network traffic. Commit has a sense only after insert, update or delete statements (And also not after each statement. Only when logic of your program needs it).

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

"Melanie Bieber" <Melanie.Bieber_at_bieber.no-ip.com> wrote in message news:<pan.2003.09.28.05.43.46.356127_at_bieber.no-ip.com>...
> Hello guys,
>
> I am looking for a official statement of oracle,
> because one of our software developer told me to commit every
> select-statement.
>
> I think, we don`t have to do that, because you do only a read-only transaction,
> so where is the reason for this???
>
> Thx4all hints...
>
> Melanie
Received on Mon Sep 29 2003 - 10:21:25 CDT