Data Warehousing Community Forum
February 09, 2012, 12:39:59 pm
Home
Help
Search
Login
Register
Data Warehousing Community Forum
>
Databases
>
Oracle
>
Control transaction statements
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Control transaction statements (Read 730 times)
Arvind
DW Apprentice
Reputation: +10/-0
Offline
Posts: 78
Control transaction statements
«
on:
June 04, 2008, 09:24:59 pm »
Can you explain, what are all the control statements which end a current transaction and makes permanant data changes to the transaction.
And also please define the
SET TRANSACTION
option !
Appreciated your help !
Logged
regards,
Arvind
Sipra
Founder
Reputation: +59/-0
Offline
Posts: 323
Am the King...
Re: Control transaction statements
«
Reply #1 on:
June 25, 2008, 02:01:57 pm »
The follwoing are the transaction control statements
COMMIT-
To make the changes done in a transaction permanent issue the COMMIT statement.
ROLLBACK -
Rollbacks the state of database to the last commit point.
SAVEPOINT -
Specify a point in a transaction to which later you can roll back..
For example -
insert into tab1(col11,col12) values (val11,val12);
savepoint a;
insert into tab2(col21,col22) values (val21,val22);
savepoint b;
Now if we give a commad -
rollback to a;
then the rows inserted into to tab2 will be roll backed.
Now we can commit the row inserted into tab1 table or rollback the transaction.
Then
SET TRANSACTION
is an Advanced Transaction Control statement which is supported in SQLJ and to specify the access mode and isolation level of any given transaction.
Logged
Sipra
Founder
www.dwforum.net
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA