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 |
how many types of sql statements are there in oracle
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment