C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Resources » Articles » General »

DDL, DML, DCL.


Posted Date: 17 Nov 2008    Resource Type: Articles    Category: General
Author: gururajanMember Level: Gold    
Rating: 1 out of 5Points: 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 2008Member 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  
Sign In to add 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



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use