---

Transaction Control Language

---

Statement used to manage the changes by DML statements and it allows statements to be grouped together into transactions. In Transaction Control Language contains two commands.

1: Commit: it make durable changes done in the data.

2: Rollback: It restores data to its state prior to user changes.

 

COMMIT Command: it makes changes permanently.

Example:

 

create table student(Roll_no number(10) , Student_name varchar2(20), Dept_name varchar2(5));
Commit;

ROLLBACK Commands: undo any changes made since transaction began.

Example:

 

create table student(Roll_no number(10) , Student_name varchar2(20), Dept_name varchar2(5));
Rollback;

 

---