Hi,
I wanted to know about the database transactions. I want to
execute a bunch of not-so-related database queries using
Oracle. I am presently using MySQL, but as I have never used
any transaction (of which I want to know the basics of), but
heard about that, I want to switch to Oracle. Now my question
is am I right?
If I am right in my understanding about the need of transaction
then how would I use the Oracle to execute say the following
statements together...
----
"select sadd from USER where uid='aaaaaa'"
"select * from INFO where sadd='uyetywetyt'"
"update INFO ...."
"update .... some other tables etc. etc."
----
I want to execute them as a bunch, if anything fails, it needs
to rollback the already executed statements.
Please help, I am a newbie in understanding transactions.
Thanks in advance
Sandip
