|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
DDL Statements [Oracle]
DDL stands for data definition language. DDL statements are SQL Statements that define or alter a data structure such as a table. Hence, a typical DDL statement is create table or alter table.
In Oracle, a (successful) DDL statement implicitely commits a transaction;
SQL> insert into ddl_test_1 values (2); SQL> create table ddl_test_2 (a number); SQL> rollback;
The create table statement implicitely commited the transaction. The insertion of the value 2 into ddl_test_1 cannot be rolled back any more.
SQL> select * from ddl_test_1; A ---------- 1 2
Since DDL changes definitions of database objects, a DDL is always reflected in the data dictionary.
See also DML statements.