【正文】 .............................................41 ...........................................................................................................................42 BY 子句：.......................................................................................... ...........................42 BY 子句的增強(qiáng).............................................................................................................43 函數(shù).........................................................................................................................43 高級子查詢....................................................................................................................................44 1. 成對子查詢：...................................................................................................................44 ...................................................................................................................................44 二、Management：.......................................................................................................................................45 .................................................................................... ...................................45 ：.......................................................................................................................46 ...................................................................................................................................46 2. 數(shù)據(jù)文件...........................................................................................................................46 3. 重做日志文件...................................................................................................................46 4. data file 數(shù)據(jù)文件： .................................................................................................46 5. 作用：存放數(shù)據(jù)。.................................................................................................................................................29 2.amp。oracle從入門到精通 : 原文信息 Oracle 從入門到精通 一、SQL...........................................................................................................................................................8 、基本概念：...................................................................................................................................8 、數(shù)據(jù)庫安全：...............................................................................................................................8 、基本的SQL SELECT 語句.............................................................................................................8 、SELECT語句...................................................................................................................................9 語法：.......................................................................................................................................9 SQL語句說明：.................................................... .....................................................................9 數(shù)字和日期都可以使用數(shù)學(xué)運算符建立表達(dá)式。amp。...........................................................................................................46 6. 數(shù)據(jù)文件大小可以擴(kuò)展。.......................................................83 2. 循環(huán)控制：................................................................... ....................................................83 3. index by tables 中的方法： .......................................................................................85 4. SQL Cursor.......................................................................................................................85 ：.............................................................................................................86 ：.......................................................................................................................87 ...................................................................................................................................88 ：...........................................................................................................................88 ：................................................................................................... ....................88 函數(shù)：.............................................................................................................................................88 存儲程序單元.................................................................................................................................90 管理PL/SQL程序塊：.....................................................................................................................91 包（package）...............................................................................................................................92 ：.......................................................................................................................................92 ：...............................................................................................................92 ............................................................. ............................................92 ：...........................................................................................................93 觸發(fā)器.............................................................................................................................................94 ：...................................................................................................................................94 ：...........................................................................................................................95 OF TRIGGER：替換類型觸發(fā)器...............................................................................96 資源來自網(wǎng)絡(luò)，僅供學(xué)習(xí)！ Oracle 從入門到精通第 6 頁，共 106 頁：..............................................