目录第一章Oracle数据库基础...........................................................................................................3§1.3SQL、SQL*Plus及PL/SQL.........................................................................................3§1.3.1SQL和SQL*PLUS的差别.................................................................................3§1.3.2PL/SQL语言........................................................................................................5§1.7ORACLE数据类型.........................................................................................................5§1.8SQL语句基础...............................................................................................................11§1.8.1SQL语句所用符号...........................................................................................11§1.8.2简单select查询.................................................................................................13第二章查询基础..........................................................................................................................13§2.1SELECT语句...............................................................................................................13§2.2SQL中的单记录函数..................................................................................................14§2.2.1单记录字符函数................................................................................................14§2.2.2单记录数字函数................................................................................................19§2.2.3单记录日期函数................................................................................................25§2.2.4单记录转换函数................................................................................................28§2.2.5其它的单记录函数............................................................................................31§2.3SQL中的组函数..........................................................................................................36§2.3.1多记录组函数....................................................................................................36§2.3.2带GROUPBY的计算....................................................................................38§2.3.3用HAVING来限制分组的计算.....................................................................38§2.4控制和格式化输出.......................................................................................................39§2.4.1用ORDERBY子句来对结果进行排序.........................................................39§2.4.2用BREAK命令来对结果进行排列.............................................................39§2.4.3用COMPUTE命令对结果进行格式化..........................................................41第三章表及索引的定义操作.....................................................................................................45§3.1建立表结构...................................................................................................................45§3.1.1建立表结构命令.................................................................................................46§3.1.2建立表结构例子.................................................................................................47§3.1.3建...
