Data Definition Language, Data Control Language and Data Manipulation Language.

Explain Data Definition Language, Data Control Language and Data Manipulation Language.

Data Definition Language (DDL):- are the SQL statements that define the database structure.

Example:

a.       CREATE

b.      ALTER

c.       DROP

d.      TRUNCATE

e.      COMMENT

f.        RENAME

Data Manipulation Language (DML):- statements are used for manipulate or edit data.

Example:

a.       SELECT - retrieve data from the a database

b.      INSERT - insert data into a table

c.       UPDATE - updates existing data within a table

d.      DELETE

e.      MERGE

f.        CALL

g.       EXPLAIN PLAN

h.      LOCK TABLE 

Data Control Language (DCL):-statements to take care of the security and authorization.

Examples:

1. GRANT
2. REVOKE