-
DML (Data Manipulation Language) - select, insert, update e delete
-
De acordo com a Oracle:
Data definition language (DDL) statements define, alter the structure of, and drop schema objects. DDL statements enable you to:
-
Create, alter, and drop schema objects and other database structures, including the database itself and database users (CREATE
, ALTER
, DROP
)
-
Change the names of schema objects (RENAME
)
-
Delete all the data in schema objects without removing the objects' structure (TRUNCATE
)
-
Grant and revoke privileges and roles (GRANT
, REVOKE
)
-
Turn auditing options on and off (AUDIT
, NOAUDIT
)
-
Add a comment to the data dictionary (COMMENT
)
DDL statements implicitly commit the preceding and start a new transaction. Some examples of DDL statements are:
CREATE TABLE plants (COMMON_NAME VARCHAR2 (15), LATIN_NAME VARCHAR2 (40)); DROP TABLE plants; GRANT SELECT ON employees TO scott; REVOKE DELETE ON employees FROM scott;
Fonte: http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/sqlplsql.htm#i18503, na data do comentário.
-
DDL - Definição (Create, Alter e Drop)
DML - Manipulação (Select, Insert, Delete e Update)
DCL - Controle (Revoke e Grant)