0 votes
in Oracle by
What is SQL and also describe types of SQL statements?

1 Answer

0 votes
by

SQL stands for Structured Query Language. SQL is used to communicate with the server in order to access, manipulate and control data. There are 5 different types of SQL statements available. They are:

Select: Data Retrieval

Insert, Update, Delete, Merge: Data Manipulation Language (DML)

Create, Alter, Drop, Rename, Truncate: Data Definition Language (DDL)

Commit, Rollback, Savepoint: Transaction Control Statements

Grant, Revoke: Data Control Language (DCL)

...