Friday, 2 September 2011

SQL Statements

This article explains the various statements available in SQL.


Data Retrival: SELECT
This statement is used to retrieve the data from the database.
Data Manipulation Language[DML]:INSERT, UPDATE, DELETE, MERGE
This statement is used to enter the new data,update the existing data, deleting the existing data and merging the data in the selected table of a database.So, these statements are called as Data Manipulation Language.
Data Definition Language[DDL]: CREATE,ALTER,DROP,RENAME, TRUNCATE
Sets up the database and removes the data from database.So, these commands are collectively known as Data Definition Language.
Transition Control: COMMIT,ROLLBACK, SAVEPOINT
These statements are used to manage the the changes made by DML statements.Changes to the data can
be grouped together into logical transactions.
Data Control Language [DCL]: GRANT,REVOKE

Gives or removes access rights to both the Oracle database and the structures within it. Collectively known as data control language.












0 comments:

Post a Comment

 
Back To Top