DDL, DML, DCL.

Posted Date: 17 Nov 2008	Resource Type: Articles	Category: General
Author: gururajan	Member Level: Gold
Rating:	Points: 5

Data Definition Language statements (DDL).

CREATE - To create objects in the database
ALTER -Alters the structure of the database
DROP -Delete objects from the database
TRUNCATE -Remove all records from a table, including all spaces allocated for the records are removed
COMMENT -Add comments to the data dictionary
GRANT -Gives user's access privileges to database
REVOKE- Withdraw access privileges given with the GRANT command

Data Manipulation Language Statements (DML)

SELECT - retrieve data from the a database
INSERT – insert data into a table
UPDATE - updates existing data within a table
DELETE – deletes all records from a table, the space for the records remain
CALL – call a PL/SQL or Java subprogram
EXPLAINS PLAN – explain access path to data
LOCK TABLE -control concurrency

DCL is Data Control Language statements.

COMMIT - save work done
SAVEPOINT - identify a point in a transaction to which you can later roll back
ROLLBACK - restore database to original since the last COMMIT
SET TRANSACTION - Change transaction options like what rollback segment to use

Responses

Author: Gaurav Arora 17 Nov 2008

Member Level: Diamond Points : 2

Hi Gurujana,

Its nice and simple article. You did a great job. It helpful for reshers.

But, as this is an article ,please post some explanatory examples so, user will enhance the skills to read this resource.

Hope you definitely will add some examples and mored escription in this resource.

Best of luck!

Thanks & regards,
Gaurav Arora

Feedbacks

Popular Tags

What are tags ?

Search Tags

DML . DDL . DCL. .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: compressed programe
	Previous Resource: Enterprise Library Application Blocks
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources