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