Re: Beginner: am I out of my depth?

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: Fri, 02 Apr 2004 19:59:36 -0500
Message-ID: <tCnbc.1025$Em4.887@fe03.usenetserver.com>

Robert C wrote:
> "AnaCDent"
>

>>Just remember ROLLBACK is your firend.

>
>
> what's COMMIT then ?
>
>

databases deal with changes in data based on transactions. A key concept is that in a given tranaction either ALL the data changes enter the database or NONE of the changes do.

So when you are at a point where you make this decision, you issue either a COMMIT WORK;
command if all the data you want in the DB has been entered or a ROLLBACK WORK;
if you decide against storing the data.

These commands affect only you session with the database, so if you issue ROLLBACK WORK;
but the guy on the next workstation does COMMIT WORK;
so his data goes in and yours does not.

FInally, in the ideal DB world a another session never sees your partial data until you issue the COMMIT; command. Lots of this is in elementary DB books and even in the ORACLE manuals.

   HTH.

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

Received on Fri Apr 02 2004 - 18:59:36 CST