Free Jobs

Java Forums: Core Java (15) J2EE (3) EJB (5) Servlet (3) JDBC (6) Hibernate (2) Struts (1) Swing (1) Oracle (7) JSP (4) Other (10)

Topic: How to differentiate among DDL, DML and DCL commands in oracle

To get the Posted Questions details daily in your mail Click Here

Share this Post on Facebook/Twitter/Orkut Bookmark and Share

User: pankaj244 Post Date: 02 Nov 2010 09:02

DDL stands for Data Definition Language
DML stands for Data Manipulation Language
DCL stands for Data Control Language
we will understand the difference among these three in this article.

Main Content:
DDL are statements used for defining the database structure or schema.
For example :
CREATE statement- to create objects in the database
ALTER statement- to alter the objects in the database
DROP - to delete the objects in the database

DML are statements used for managing data within schema objects.
For example :
SELECT statement- to retrieve data from the a database
INSERT statement- to insert data into a table
UPDATE - to updates existing data

DCL are statements used for controling the access of data.
For example :
GRANT statement- to give access privileges to database
REVOKE statement- to withdraw access privileges

DDL statements are auto-commit means you cant roll back them.
while DML are not auto-commit. i.e. you can roll-back the operations

About Writer:
Hi , I am Oracle Developer From Bangalore

Writer's Link:

Writer's Email:

Post Comment

Similar Articles Top ArticlesLatest Articles Other Articles by this Author Copyright © 2009-2011 | All Rights Reserved
All content of this website is protected by copyright laws and should not be reproduced in any form or by any means without written permission
(Best viewed in IE 8.0+ or Firefox 3.0+ at resolution of 1024 * 768 or higher)