What is a DDL, DML, DCL, TCL and DSPL concept in RDBMS world?
CREATE TABLE – creates new database table
ALTER TABLE – alters or changes the database table
DROP TABLE – deletes the database table
CREATE INDEX – creates an index or used as a search key
DROP INDEX – deletes an index
The Data Manipulation Language (DML) includes,
SELECT – extracts data from the database
UPDATE – updates data in the database
DELETE – deletes data from the database
INSERT INTO – inserts new data into the database
The Data Control Language (DCL) includes,
GRANT – gives access privileges to users for database
REVOKE – withdraws access privileges to users for database
The Transaction Control (TCL) includes,
COMMIT – saves the work done
ROLLBACK – restore the database to original since the last COMMIT
DSPL – Database Stored Procedure Language came to relational databases relatively late in the game – and thus the languages used for triggers, event handlers, and stored procedures are completely different among the database vendors. Oracle’s PL/SQL is quite different even in statement syntax from SQL Server’s Transact SQL which in turn differs again from DB2′s Stored Procedure language. And of course given the underlying differences in DDL, DML, and DCL it is inevitable that the stored procedure languages would vary in content as well as syntax.
No comments:
Post a Comment