Oracle Database 10g Express Edition PHP Web Programming

Data Control Language (DCL)

Data Control Language (DCL) is the ability to guarantee an all-or-nothing approach when changing data in more than one table. Table H-4 covers the key commands involved in DCL to manage transactions.

Table H-4. DCL Statements

Statement	Description
COMMIT	The COMMIT statement makes permanent all DML changes to data up to that point in the user session. Once you commit data changes, they are permanent unless you perform some form of point-in-time database recovery. It has the following prototype: COMMIT
ROLLBACK	The ROLLBACK statement reverses changes to data that have not yet become permanent through being committed during a user session. The ROLLBACK makes sure all changes are undone from the most recent DML statement ...