DBA

Search This Blog

DBA

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Types of SQL Statements in Oracle Database

SQL Statements in Oracle Database can be divided into followings: Data Definition Language (DDL) : CREATE, ALTER, DROP, RENAME, COMMENT, TRUNNCATE, PURGE, FLASHBACK, ANALYZE, AUDIT, NOAUDIT, ASSOCIATE STATISTICS, DISASSOCIATE STATISTICS Data Control Language (DCL) : GRANT, REVOKE Data Manipulation Language (DML) : INSERT, UPDATE, DELETE, MERGE, CALL, LOCK TABLE, EXPLAIN PLAN Data Query Language (DQL) : SELECT Transaction Control Language (TCL) : SAVEPOINT, COMMIT, ROLLBACK, SET TRANSACTION, SET CONSTRAINT Session Control Statements : ALTER SESSION, SET ROLE System Control Statements : ALTER SYSTEM Embedded SQL Statements : DDL, DML, TCL within procedural language program like COBOL, C, C++

Data & Database

Where is the wisdom? Lost in the knowledge. Where is the knowledge? Lost in the information. — T. S. Eliot Where is the information? Lost in the data. Where is the data? Lost in the #@%&! database! — Joe Celko

Powered by Blogger

Theme images by A330Pilot

mjaKHAN

DBA

Comments

Post a Comment