Definition of DDL , DML , DCL , TCL
DDL : Full form of DDL is Data Definition Language. It is used to create and database objects in a database.Eg: CREATE, ALTER, DROP.
DML: Full form of DML is Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.Eg: INSERT, UPDATE, DELETE,SELECT.
DCL : Full form of DCL is Data Control Language. It is used to create and revoke roles & permissions. It is used to control access to database by allowing access only to the valid users . Eg: GRANT, REVOKE.
TCL : Full form of TCL is Transactional Control Language which is used to handle transactions occurring within the database.Eg: COMMIT, ROLLBACK and Save Point.
HIMANSHU SOLANKI (@himansh13825459) said:
Yaa This is very useful for me!!
and my request to mister pawan please update some more details about sql
LikeLiked by 1 person
Navjeet Gambhir said:
It is used to create and database objects in a database I think this Statement needs some correction