oracle分析函数lag、lead:
http://blog.csdn.net/mazongqiang/article/details/7621330
oracle分析函数over:
http://www.cnblogs.com/wuyisky/archive/2010/02/24/oracle_over.html
oracle分析排名函数rank、dense_rank、row_number:
http://www.cnblogs.com/wuyisky/archive/2010/02/24/oracle_rank.html
SQL*PLUS命令的使用大全:
http://www.cnblogs.com/wuyisky/archive/2010/04/07/1705979.html
oracle中date与timestamp比较:
http://www.cnblogs.com/lz-cswb/archive/2012/04/29/2476329.html
PL/SQL学习笔记一到七:
http://www.bitscn.com/pdb/oracle/200604/16863.html