1、纲要............................................................................................................................................42、内容............................................................................................................................................42.1、SQL概述.........................................................................................................................42.2、什么是数据库.................................................................................................................42.3、表.....................................................................................................................................52.4、SQL的分类.....................................................................................................................52.5、演示数据的结构.............................................................................................................52.5.1、怎么样可以取得演示数据表...............................................................................52.5.2、如何查看表结构...................................................................................................62.5.3、表结构描述...........................................................................................................62.6、简单查询.........................................................................................................................72.6.1、查询一个字段.......................................................................................................72.6.2、查询多个字段.......................................................................................................72.6.3、查询全部字段.......................................................................................................82.6.4、计算员工的年薪...................................................................................................82.6.5、将查询出来的字段显示为中文...........................................................................92.7、SQLPlus常用命令.........................................................................................................92.7.1、setlinesize200......................................................................................................92.7.2、l(List)..................................................................................................................102.7.3、run/r...................................................................................................................102.7.4、save.....................................................................................................................112.7.5、get........................................................................................................................112.7.6、ed(edit)................................................................................................................112.7.7、如何直接执行sql脚本......................................................................................122.8、条件查询.......................................................................................................................122.8.1、等号操作符.........................................................................................................122.8....
