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
Online Classes
Contact Us: +919885348743