Oracle中SQL语句分类如下:
1.DML语句
insert/delete/update/select/merge/explan plan/lock table
2.DDL语句
create/atlter/drop/truncate/rename/grant/revoke/audit/noaudit
3.DCL
事务控制语句:commit/rollback/savepoint/set transaction
会话控制语句:alter session set...
系统控制语句:alter system
嵌入式SQL语句(E-SQL):declare cursor,open,close
declare database,connect
declare statement/describe/whenever/prepare,excute
execute immdiate/fetch