Oracle DML DDL DCL TCL

ORACLE DML Statement (Data manipulation language)

1.Delete : Delete all records from a table , the space for the record remain.
2.Insert : Insert data in a table.
3.Marge : Upsets operation (insert & update).
4.Select : Retrieve data from a table
5.Update : Update existing data within a table.
6.Call : Call a PL/SQL or Java program.
7.Lock table   : Control concurrency.


DCL (Data Control Language)

1.Grant : Gives user access privileges to database.
2.Revoke : Withdraw access privileges given with the grant command.


TCL(Transaction Control)

1.Commit : Save work done.
2.Save point : Indentify a point in a transition to which you can latter rollback.
3.Rollback : Restore database to original since the last commit.
4.Set transition: Change transition option like  isolation level and what rollback segment to use.


DDL(Data Definition language)

1.Create : To create object in the database.
2.Alter : Alter the structure of the database.
3.Drop : Delete object of the database.
4.Truncate : Remove the record from a table, including all spaces allocated for the record are removed.
5.Commit : Add commends to the data dictionary.
6.Rename : Rename an object.


Ur's
AmarAlam