Types of SQL Statements in Oracle Database

on

Oracle SQL

 SQL Statements in Oracle Database can be divided into followings:

  1. Data Definition Language (DDL) : CREATE, ALTER, DROP, RENAME, COMMENT, TRUNNCATE, PURGE, FLASHBACK, ANALYZE, AUDIT, NOAUDIT, ASSOCIATE STATISTICS, DISASSOCIATE STATISTICS
  2. Data Control Language (DCL) : GRANT, REVOKE
  3. Data Manipulation Language (DML) : INSERT, UPDATE, DELETE, MERGE, CALL, LOCK TABLE, EXPLAIN PLAN
  4. Data Query Language (DQL) : SELECT 
  5. Transaction Control Language (TCL) : SAVEPOINT, COMMIT, ROLLBACK, SET TRANSACTION, SET CONSTRAINT
  6. Session Control Statements : ALTER SESSION, SET ROLE
  7. System Control Statements : ALTER SYSTEM
  8. Embedded SQL Statements : DDL, DML, TCL within procedural language program like COBOL, C, C++

Comments

Post a Comment