how many types of sql statements are there in oracle

There are basically 6 types of sql statement
Data Definition Language(DDL) - The DDL  statements define and maintain objects and drop objects.
 
Data Manipulation Language(DML) - The DML statements manipulate database data.
 
Transaction Control Statements - Manage change by DML
 
Session Control - Used to control the properties of current session enabling and disabling roles and changing .e.g.,  Alter Statements, Set Role
 
System Control Statements - Change Properties of Oracle Instance .e.g., Alter System
 
Embedded Sql - Incorporate DDL,DML and T.C.S in Programming Language.e.g.,Using the Sql Statements in languages such as 'C', Open,Fetch, execute and close
 

No comments:

Post a Comment