How Many Types Of Sql Statements Are There In Oracle?

1.	How Many Types Of Sql Statements Are There In Oracle?
Answer» There are BASICALLY 6 TYPES of sql statments.They are 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 There are basically 6 types of sql statments.They are

Answer»

There are BASICALLY 6 TYPES of sql statments.They are

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

There are basically 6 types of sql statments.They are

Discussion