skip to main content
Non-Supported SQL-92 functionality : Transaction control statements : COMMIT
 

COMMIT

This statement ends your current transaction and makes permanent all changes performed in the transaction. A transaction is a sequence of SQL statements that the data source treats as a single unit. This statement also releases the transaction's locks.

Syntax 

COMMIT

Example 

INSERT INTO emp(empno, ename) values(10,'alpha')
COMMIT