A Data Control Language is a computer language for controlling access to data in a database. Examples of DCL commands are A computer language is a language used by, or in association with, computers. ...
GRANT to allow specified users to perform specified tasks.
DENY to disallow specified users from performing specified tasks.
REVOKlE to cancel previously granted or denied permissions.
UPDATE to allow a user to update records
READ disallows a user to edit the database, can only view the data
DELETE allows a user to delete records in a database
Data Definition Language is the part of SQL that used to create database, modify database structure and destroy unwanted database.
Data Manipulation Language (DML) is the part of SQL that insert, retrieve, modify and delete the data contained in database.
Structured Query Language (SQL) was originated from one of the IBM research lab in 1974 and 1975 while IBM was doing early research on a relational database called System /R, SQL was created to manipulate the prototype database.
Data Manipulation Language (DML) is a family of computer languages used by computer programs or database users to retrieve, insert, delete and update data in a database.
Data manipulation languages were initially only used by computer programs, but (with the advent of SQL) have come to be used by people, as well.
Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb.
Feeds |
Contact