PLSQL培训手册.ppt

1 CompanyConfidential - For internal use only PL/SQL培训 2 CompanyConfidential - For internal use only 目录 目录...............................................................................................................................................................................................................2 UNIT1 SQL、PL/SQL 概要 ...............................................................................................................................................................1 单元培训目标................................................................................................................................................................................1 LESSON 1 SQL 、SQL*Plus 和 PL/SQL基本概念 .............................................................................................................1 UNIT2 数据查询..................................................................................................................................................................................3 单元培训目标................................................................................................................................................................................3 LESSON 1简单的数据查询.......................................................................................................................................................3 LESSON 2 SQL*Plus 的使用.....................................................................................................................................................5 LESSON 3 单行函数的使用......................................................................................................................................................6 LESSON 3多表数据查询...........................................................................................................................................................7 LESSON 4组函数 .......................................................................