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.

Welcome your suggestion