In this lesson we are going to study about Transaction control language.
There are three transaction control statement used to control transaction they are :
All changes in oracle database can only be done within a transaction .
Transaction :
Example:
A transfer of funds between two accounts should include the debit to one account and the credit to another account in same transaction .Both actions should either fail or succeed together,the credit should not be committed wihtout the debit .
Related Article:
I am interested in hearing your feedback, so that I can improve my articles and learning resources for you.connect with us on facebook, twitter
Transaction control language(TCL):
There are three transaction control statement used to control transaction they are :
- Commit
- Rollback
- Savepoint
All changes in oracle database can only be done within a transaction .
Transaction :
- Transactions is an execution of sequence of SQL statements which modifies the data in the database.
- Transactions should either end with a COMMIT or ROLLBACK statement.
- Transaction ensure the data consistency.
Example:
A transfer of funds between two accounts should include the debit to one account and the credit to another account in same transaction .Both actions should either fail or succeed together,the credit should not be committed wihtout the debit .
Related Article:
I am interested in hearing your feedback, so that I can improve my articles and learning resources for you.connect with us on facebook, twitter
No comments:
Post a Comment