Which types of SQL statements are classified?

System Environment:

1, Database:Oracle 8i R3 ( 8.1.7 ) For NTEnterprise Edition

 

Note:

 

DDL . Data Definition Language: Create , alter , drop , truncate (create, modify, delete, and truncation) (others: rename )

 

DML, Data control language:Insert,Delete,Select,Update(Add, delete, query, and modify)

 

DCL, Data control language:Grant,Revoke(Authorization, recycling ),Set role

 

Transaction Control: Commit , Rollback , Savepoint (Others: Lock table , Set constraint (s) , SET transaction )

 

Audit Control:Audit,Noaudit

 

System Control:Alter System

 

Session control:Alter session

 

Other statements:Comment(Add comments ),Explain plan,Analyze(Collect statistics ),Validate,Call