SQL的分类:
1)数据定义语言(DDL):Create,ALTER,Drop,TRUNCATE,COMMENT,RENAME等;
2)数据操纵语言(DML):SELECT,Update,Insert,Delete,MERGE,CALL,EXPLAIN PLAN,LOCK TABLE等(注意,DML语句,需要在脚本最后添加commit提交操作);
3)数据控制语言(DCL):Commit,Rollback,Savepoint,Grant,Revoke等;
4)事务控制语言(TCL):SAVEPOINT 设置保存点,ROLLBACK 回滚,SET TRANSACTION;
5) 其他:Alter System,Connect,Allocate等。
SQL语句
1、创建表语句
create table tabname (col1 type1 [not null] [primary key], col2 type2 [not null], ..)
2、循环
(1)基本循环
LOOP
statement1;
......
EXIT [WHEN condition];
END LOOP;
(2)while循环
WHILE condition LOOP
statement1;
statement2;
.....
END LOOP;
(3)for循环
FOR counter in [REVERSE] lower_bound. .upper_bound LOOP
statement1;
statement2;
.......
END LOOP;
(4)嵌套循环
详见博文:http://www.cnblogs.com/fromchaos/archive/2012/06/07/2540219.html