Understanding Of Data Defination Language. Data Defination Language is one of the sub Language of SQL Language. In previous post i have describe all sub language of sql. Now in this post i am going to explain about Data Defination Language. This Language is specially designed to define Database objects such as TABLE, VIEWS,STORED PROCEDURE, FUNCTION and TRIGGER e.t.c.
A Data Defination Language is pre-defined syntax for describing data.
Enjoye your shopping with offerbaba
DATA DEFINATION LANGUAGE enables you to perform such operation on database.
CREATE, ALTER and DROP scheema objects
GRANT and REVOKE privildges and ROLEs
Analyze information on a TABLE, INDEX, or CLUSTER
Establshing auditing options
Add conmments to DATA DICTONARY
DDL(Data Defination Language) are as follows:
Keep visiting for more on Oracle
Thank you(Smartyy Sunny)