Oracle SQL Statement Types



Share this article :

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.

Related posts

ORA-00257: archiver stuck
Copy SQL Table in Oracle
How to Find / List Available Schema in Oracle
How to Change Oracle Listener Default Name
© 2017 ITsiti. All Rights Reserved
Powered by KEEM