Data Definition Language (DDL) Statements
Data definition language (DDL) statements let you to perform these tasks:
• Create, alter, and drop schema objects
• Grant and revoke privileges and roles
• Analyze information on a table, index, or cluster
• Establish auditing options
• Add comments to the data dictionary
Data Manipulation Language (DML) Statements
Data manipulation language (DML) statements access and manipulate data in existing schema objects. These statements do not implicitly commit the current transaction. The data manipulation language statements are:
• CALL
• DELETE
• EXPLAIN PLAN
• INSERT
• LOCK TABLE
• MERGE
• SELECT
• UPDATE
Transaction Control Statements
Transaction control statements manage changes made by DML statements. The transaction control statements are:
• COMMIT
• ROLLBACK
• SAVEPOINT
• SET TRANSACTION
Session Control Statements
Session control statements dynamically manage the properties of a user session. These statements do not implicitly commit the current transaction. PL/SQL does not support session control statements. The session control statements are:
• ALTER SESSION
• SET ROLE
System Control Statement
The single system control statement, ALTER SYSTEM, dynamically manages the properties of an Oracle Database instance.
Embedded SQL Statements
Embedded SQL statements place DDL, DML, and transaction control statements within a procedural language program.
