Ｏｒａｃｌｅ数据库系统教案目录目录专题一Oracle入门...........................................................................................................................11.教学目标........................................................................................................................12.工作任务........................................................................................................................13.相关实践知识................................................................................................................13.1Oracle10g的安装和卸载....................................................................................13.2用NetConfigurationAssistant配置客户端服务名.........................................103.3启动Oracle服务...............................................................................................163.4认识Oracle常用工具.......................................................................................183.5创建数据库和表空间........................................................................................243.6Oracle中的用户管理.........................................................................................324.实验..............................................................................................................................345.课后作业......................................................................................................................35专题二锁和表分区.........................................................................................................................361.教学目标......................................................................................................................362.工作任务......................................................................................................................363.相关实践知识..............................................................................................................363.1使用行级锁和时间戳来保证数据完整性........................................................363.2使用表级锁........................................................................................................403.3使用表分区........................................................................................................434.提高..............................................................................................................................495.实验..............................................................................................................................506.课后作业......................................................................................................................50专题三SQL语句和SQL函数.......................................................................................................52教学目标...........................................................................................................................52案例一Oracle数据库中的DDL、DML和DCL.................................................................531.教学目标......................................................................................................................532.工作任务.......................................................................................................
