Monday 5 January 2015

SQL Statements in oracle

SQL Statements can be classified as follows.
SQL Statements
Data Definition Language (DDL)
Database Structure can be created or alter using DDL Statements. Create, alter, drop, rename and truncate are few of them.
DDL Statements are Auto Commit.
CREATE
ALTER
DROP
RENAME
TRUNCATE
Data Manipulation Language (DML)
Once the database structured is created you can insert, update, delete or merge data.
DML Statements manipulate table's data.
INSERT
UPDATE
DELETE
MERGE
Data Retrieval Language (DRL)
Data Retrieval language retrieves information from tables.


SELECT
Transaction Control Language (TCL)
Transaction control language controls the transactions.
COMMIT
ROLLBACK
SAVEPOINT
Data Control Language (DCL)
Data Control Language is used for permission. 
GRANT
REVOKE

No comments:

Post a Comment