Transaction Control Language (TCL)

Database transactions:

In a database, transaction means successful execution of a SQL statements with valid changes on the database. A database transaction consists of one of the following :


Transactions give you more flexibility and control when changing data, and they ensure data consistency in the event of user process failure or system failure.

Start and end of a transaction:


A transaction begins when a first DML statement is executed and ends when one of the following occurs :


Explicit transaction control statement:

Advantages of explicit transaction control statement:



  Tutorials

Popular Links

Contact Us

address Plot No-741,2ND Floor
Opp. Bhagabati Temple,Jayadev Vihar
      Bhubaneswar-751013
      Email: info@silantechnology.com
      Phone: 0674-2361252
address
39877, sundale dr, apt#101, Fremont, California 94538, USA
       Phone: +1(262)388-7619

facebook twitter google linked in

© 2018 Silan Technology. All Rights Reserved