Oracle SQL - DDL statements

DDL Statements: analyze, associate statistics, audit, comment, create ..., disassociate statistics, drop ... , flashback ... , grant, noaudit, purge, rename, revoke, truncate table

Statements beginning with alter except alter system and alter system statements (which are session control and system control statements respectively) are also DDL statements.

The database changes that are caused by a DDL statement are reflected in the data dictionary.

DDL statements without DML compenents (such as create table as select …) do not undergo SQL statement optimization.

A DDL statement commits the current transaction (but creation of a temporary table, such as a private temporary table) does not).

The create schema statement can be used to create multiple tables and views and/or grant multiple privileges in a single transaction.