Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How many types of sql statements are there in Oracle?

April 26, 2017Oracle sql statements types

0

Posted

How many types of sql statements are there in Oracle?

1 Answer

0

Posted

There are basically 6 types of sql statements. They are:a) Data Definition Language (DDL)The DDL statements define and maintain objects and drop objects.b) Data Manipulation Language (DML)The DML statements manipulate database data.c) Transaction Control StatementsManage change by DMLd) Session ControlUsed to control the properties of current session enabling and disabling roles and changing. E.g. Alter Statements, Set Rolee) System Control StatementsChange Properties of Oracle Instance. E.g. Alter Systemf) Embedded SqlIncorporate DDL, DML and TCS in Programming Language. E.g.