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

V$ARCHIVE_DEST: Archived Redo Log Instance Destinations State
SP2-0750: You may need to set ORACLE_HOME to your Oracle
Where to Find Oracle Listener Port & How to Change It
Steps to Upgrade Oracle Opatch Utility
© 2018 ITsiti. All Rights Reserved
Powered by KEEM