SQL - Transaction Control (TCL)

Data System Architecture

About

In SQL, TCL means Transaction Control and is a set of commands that manage the effectiveness of a DML action.

The principal commands are:

  • COMMIT to validate the changes
  • ROLLBACK to cancel the changes and return to the previous state of the data (since the last COMMIT)

but you can also find:

  • SAVEPOINT to create a point in a transaction (series of SQL statement) where you can later roll back
  • SET TRANSACTION to change transaction properties like isolation level, which rollback segment to use
  • SET CONSTRAINT





Discover More
Card Puncher Data Processing
Glossary

(CREATE, ALTER, DROP) (GRANT, REVOKE) (SELECT, UPDATE, INSERT, DELETE) (COMMIT, ROLLBACK) NLS (National Language Support) UDML is the abbreviation for Universal Database Markup Language ...
Owb Mapping Configuration
OWB - Mapping Configuration

What means the different values configuration of a mapping. Properties Description Deployable If you disable it, scripts for that mapping are not generated. Language Warehouse Builder sets...
Card Puncher Data Processing
Oracle Database - Transactions

All Oracle transactions comply with the basic properties of a database transaction, known as ACID properties. A transaction begins when the first executable SQL statement is encountered. An executable...
Data System Architecture
SQL - Statement (Type)

in SQL. Session Control Statements (Alter session, Set Role) System Control Statement (Alter System) Embedded Control Statements (Any DML, DDL or TCL that is integrated into a...



Share this page:
Follow us:
Task Runner