目录第一章初识Oracle......................................................................................................................................41.11.1Oracle简介...............................................................................................................................51.21.2Oracle安装...............................................................................................................................61.31.3Oracle客户端工具.................................................................................................................111.3.11.3.1SQL*Plus工具.............................................................................................................111.3.21.3.2SQL*Plus命令行工具.................................................................................................121.3.31.3.3配置本地网络服务名..................................................................................................141.3.41.3.4PL/SQLDeveloper工具..............................................................................................181.41.4Oracle服务.............................................................................................................................181.51.5Oracle启动和关闭.................................................................................................................201.61.6Oracle用户和权限.................................................................................................................211.71.7本章总结.................................................................................................................................241.81.8本章练习.................................................................................................................................25第二章数据查询和操作.............................................................................................................................272.12.1SQL简介................................................................................................................................282.22.2Oracle数据类型.....................................................................................................................282.32.3创建表和约束.........................................................................................................................302.42.4数据操纵语言(DML)........................................................................................................322.4.12.4.1简单查询......................................................................................................................322.4.22.4.2数据插入......................................................................................................................342.4.32.4.3更新数据......................................................................................................................362.4.42.4.4删除数据......................................................................................................................362.4.52.4.5TRUNCATE.................................................................................................................372.52.5操作符.......................................................................................................................................