Re: how to auto commit in oracle?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 08 May 2003 05:52:46 GMT
Message-ID: <Ngmua.5457$In4.1491@news02.roc.ny.frontiernet.net>

"Noel" <tbal_at_go2.pl> wrote in message news:b9al83$8hd$1_at_inews.gazeta.pl...
>
> Uzytkownik "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> napisal w wiadomosci
> news:a20d28ee.0305070125.67d03526_at_posting.google.com...
> > "Xie Haifeng" <xiehaifeng_at_hotmail.com> wrote in message
> news:<b9aall$h2aam$1_at_ID-179281.news.dfncis.de>...
> > > Hi all,
> >
> > I would recommend seriously you to try to *LEARN* Oracle, instead of
> > porting bad habits of other products to Oracle.
>
> I quite agree.
> He will learn, when he accidentally delete tons of rows instead of only a
> view,
> forgetting to put where clause in your sql statetment, leaving no rollback
> command while autocommit will be on.
> Sounds like suiccide.

dbms_flashback will save him/her in 9i <grin>

Anurag

> --
> Noel.
>
>
>
>
> --
> Serwis Usenet w portalu Gazeta.pl -> http://www.gazeta.pl/usenet/
Received on Thu May 08 2003 - 00:52:46 CDT