【正文】 Ｏｒａｃｌｅ數(shù)據(jù)庫系統(tǒng)教案197 / 197目錄目錄專題一Oracle入門........................................................................................................................... 11.教學(xué)目標(biāo)........................................................................................................................ 12.工作任務(wù)........................................................................................................................ 13.相關(guān)實(shí)踐知識(shí)................................................................................................................ 1Oracle10g的安裝和卸載.................................................................................... 1用NetConfigurationAssistant配置客戶端服務(wù)名......................................... 10啟動(dòng)Oracle服務(wù)............................................................................................... 16認(rèn)識(shí)Oracle常用工具....................................................................................... 18創(chuàng)建數(shù)據(jù)庫和表空間........................................................................................ 24Oracle中的用戶管理......................................................................................... 324.實(shí)驗(yàn).............................................................................................................................. 345.課后作業(yè)...................................................................................................................... 35專題二鎖和表分區(qū)......................................................................................................................... 361.教學(xué)目標(biāo)...................................................................................................................... 362.工作任務(wù)...................................................................................................................... 363.相關(guān)實(shí)踐知識(shí).............................................................................................................. 36使用行級(jí)鎖和時(shí)間戳來保證數(shù)據(jù)完整性........................................................ 36使用表級(jí)鎖........................................................................................................ 40使用表分區(qū)........................................................................................................ 434.提高.............................................................................................................................. 495.實(shí)驗(yàn).............................................................................................................................. 506.課后作業(yè)...................................................................................................................... 50專題三SQL語句和SQL函數(shù)....................................................................................................... 52教學(xué)目標(biāo)........................................................................................................................... 52案例一Oracle數(shù)據(jù)庫中的DDL、DML和DCL................................................................. 531.教學(xué)目標(biāo)...................................................................................................................... 532.工作任務(wù)...................................................................................................................... 533.相關(guān)實(shí)踐知識(shí).............................................................................................................. 534.實(shí)驗(yàn).............................................................................................................................. 675.課后作業(yè)...................................................................................................................... 67案例二Oracle數(shù)據(jù)庫中的函數(shù)及子查詢............................................................................. 681.教學(xué)目標(biāo)...................................................................................................................... 682.工作任務(wù)...................................................................................................................... 683.相關(guān)實(shí)踐知識(shí).............................................................................................................. 68綜合使用各種函數(shù)............................................................................................ 68字符函數(shù)............................................................................................................ 78數(shù)字函數(shù)............................................................................................................ 81日期函數(shù)............................................................................................................ 84轉(zhuǎn)換函數(shù)............................................................................................................ 854.實(shí)驗(yàn).............................................................................................................................. 86I目錄5.課后作業(yè)...................................................................................................................... 86專題四數(shù)據(jù)庫對(duì)象......................................................................................................................... 871.教學(xué)目標(biāo)...................................................................................................................... 872.工作任務(wù)...................................................................................................................... 873.相關(guān)實(shí)踐知識(shí).............................................................................................................. 87使用同義詞........................................................................................................ 87使用序列實(shí)現(xiàn)自增主鍵.................................................................................... 89使用視圖............................................................................................................ 92使用索引加快表的查詢.................................................................................... 994.實(shí)驗(yàn)............................................................................................................................ 1085.課后作業(yè)..................................................