DML DDL TCL

In addition to the creation of data manipulation  objects  the actual manipulation of data within these objects is done using SQL
            The SQL sentences that are used to create these objects are called DDL’s or Data Definition Language. The SQL sentences used to manipulation data within these objects are called DML’s or Data Manipulation Language. The SQL sentences, which are used to control the behavior of these objects, are called DCL’s or Data Control Language.
            Hence, once access to the SQL *PLUS tool is available and SQL syntax is known the creation of data storage and the manipulation of data within the storage system, required by commercial applications is possible.

Data Definition Language----CREATE,ALTER,DROP,GRANT and REVOKE
Data Manipulation Language---INSERT,SELECT,DELETE and UPDATE
Transaction Control Language----COMMIT,ROLLBACK,SAVEPOINT

For
Online Classes

Contact Us: +919885348743