quinta-feira, 4 de agosto de 2011

Implicit COMMIT occurs with

DCL (Data Control Language) and DDL (Data Definition Language) statements cause an implicit commit when issued.

DCL statements consist of commands such as GRANT and REVOKE and are used to control access to the database and data.

DDL statements are used to create database objects and consist of statements like CREATE, DROP, ALTER, and RENAME.