!oracle數(shù)據(jù)庫(kù)設(shè)計(jì)

1、海頤軟件股份有限公司ACLE技術(shù)文檔之一源碼網(wǎng)整理：第1頁(yè)共83頁(yè)保密保密1目錄目錄第1章acle數(shù)據(jù)庫(kù)安裝配置數(shù)據(jù)庫(kù)安裝配置......................................................................................................31.1配置監(jiān)聽(tīng)程序配置監(jiān)聽(tīng)程序.......................................

2、....................................................................................31.2配置網(wǎng)絡(luò)服務(wù)名配置網(wǎng)絡(luò)服務(wù)名......................................................................................................................

3、.4第2章管理用戶(hù)訪問(wèn)章管理用戶(hù)訪問(wèn)........................................................................................................................42.1表空間、用戶(hù)及方案概述表空間、用戶(hù)及方案概述........................................................

4、............................................42.2用戶(hù)訪問(wèn)用戶(hù)訪問(wèn)................................................................................................................................52.3創(chuàng)建用戶(hù)創(chuàng)建用戶(hù)........................

5、........................................................................................................62.4修改用戶(hù)修改用戶(hù)........................................................................................................

6、........................62.5鎖定用戶(hù)賬戶(hù)鎖定用戶(hù)賬戶(hù)...........................................................................................................................72.6解鎖用戶(hù)賬戶(hù)解鎖用戶(hù)賬戶(hù).........................................

7、..................................................................................72.7默認(rèn)角色默認(rèn)角色..............................................................................................................................

8、.....72.8授予用戶(hù)訪問(wèn)權(quán)授予用戶(hù)訪問(wèn)權(quán).......................................................................................................................72.9撤消用戶(hù)撤消用戶(hù)..................................................................

9、..............................................................92.10廢除用戶(hù)訪問(wèn)廢除用戶(hù)訪問(wèn)........................................................................................................................92.11創(chuàng)建角色創(chuàng)建角色........

10、........................................................................................................................92.12新建的用戶(hù)怎樣才能成功創(chuàng)建一個(gè)表新建的用戶(hù)怎樣才能成功創(chuàng)建一個(gè)表...............................................................

11、................10第3章建立和管理表建立和管理表......................................................................................................................113.1簡(jiǎn)介簡(jiǎn)介............................................................

12、..........................................................................123.2建表建表......................................................................................................................................133

13、.3修改表修改表..................................................................................................................................143.4截?cái)嗪蛣h除表截?cái)嗪蛣h除表.................................................................

14、.....................................................143.5顯示表信息顯示表信息..........................................................................................................................15第4章acle操作符操作符...............

15、....................................................................................................16第5章基本查詢(xún)基本查詢(xún)...........................................................................................................

16、.................195.1簡(jiǎn)單查詢(xún)語(yǔ)句簡(jiǎn)單查詢(xún)語(yǔ)句......................................................................................................................195.2排序數(shù)據(jù)排序數(shù)據(jù).......................................................

17、.......................................................................21第6章復(fù)雜查詢(xún)復(fù)雜查詢(xún)............................................................................................................................226.1數(shù)據(jù)分組數(shù)據(jù)分

18、組..............................................................................................................................226.2連接查詢(xún)連接查詢(xún)................................................................................

19、..............................................236.3相等連接（包括相等連接（包括SQL：1999標(biāo)準(zhǔn)內(nèi)連接、自然連接）標(biāo)準(zhǔn)內(nèi)連接、自然連接）................................................246.4不等連接不等連接................................................................

20、..............................................................246.5自連接自連接..................................................................................................................................246.6[內(nèi)連接和內(nèi)連接和]外連

21、接外連接...............................................................................................................246.6.1內(nèi)連接內(nèi)連接............................................................................................

22、..................256.6.2左外連接左外連接..........................................................................................................256.6.3右外連接右外連接..................................................................

23、........................................256.6.4完全外連接完全外連接......................................................................................................256.7子查詢(xún)子查詢(xún)..................................................

24、................................................................................256.7.1單行子查詢(xún)（單列）單行子查詢(xún)（單列）.............................................................................................256.7.2多行子查詢(xún)（單列）多行子查詢(xún)（

25、單列）.............................................................................................256.7.3多列子查詢(xún)多列子查詢(xún)...........................................................................................................

26、..26海頤軟件股份有限公司ACLE技術(shù)文檔之一源碼網(wǎng)整理：第3頁(yè)共83頁(yè)保密保密314.1過(guò)程過(guò)程........................................................................................................................................7114.1.1建立過(guò)程建立過(guò)程..................

27、.............................................................................................7114.1.2顯示過(guò)程代碼顯示過(guò)程代碼.......................................................................................................7214

28、.2函數(shù)函數(shù)........................................................................................................................................7214.2.1建立函數(shù)建立函數(shù)..............................................................

29、.................................................7214.2.2刪除函數(shù)刪除函數(shù)...............................................................................................................7314.2.3顯示函數(shù)代碼顯示函數(shù)代碼........................

30、...............................................................................7314.3包......................................................................................................................................

31、......7314.3.1建立包規(guī)范建立包規(guī)范...........................................................................................................7314.3.2建立包體建立包體.........................................................................

32、......................................7414.3.3刪除包刪除包...................................................................................................................7514.3.4顯示包代碼顯示包代碼...................................

33、........................................................................7514.4觸發(fā)器觸發(fā)器....................................................................................................................................7514

34、.4.1語(yǔ)句觸發(fā)器語(yǔ)句觸發(fā)器...........................................................................................................7514.4.2行觸發(fā)器行觸發(fā)器...................................................................................

35、............................7614.4.3使用觸發(fā)器的注意事項(xiàng)使用觸發(fā)器的注意事項(xiàng).......................................................................................7714.4.4編譯觸發(fā)器編譯觸發(fā)器...........................................................

36、................................................7714.4.5刪除觸發(fā)器刪除觸發(fā)器...........................................................................................................7714.4.6顯示觸發(fā)器代碼顯示觸發(fā)器代碼.........................

37、..........................................................................77第十五章第十五章使用使用EXP和IMP.........................................................................................................7715.1使用使用EXP.......

38、........................................................................................................................7815.1.1導(dǎo)出表導(dǎo)出表......................................................................................

39、.............................7815.1.2導(dǎo)出方案導(dǎo)出方案...............................................................................................................7815.1.3導(dǎo)出數(shù)據(jù)庫(kù)導(dǎo)出數(shù)據(jù)庫(kù)..............................................

40、.............................................................7815.2使用使用IMP...............................................................................................................................7815.2.1導(dǎo)入表導(dǎo)入表.....

41、..............................................................................................................7915.2.2導(dǎo)入方案導(dǎo)入方案..............................................................................................

42、.................7915.2.3導(dǎo)入數(shù)據(jù)庫(kù)導(dǎo)入數(shù)據(jù)庫(kù)...........................................................................................................79第1章acle數(shù)據(jù)庫(kù)安裝配置數(shù)據(jù)庫(kù)安裝配置當(dāng)安裝acleDatabase時(shí)，如果沒(méi)有建立數(shù)據(jù)庫(kù)，在安裝完成之后可以使用DBCA工具建立數(shù)據(jù)庫(kù)。數(shù)據(jù)庫(kù)配置

43、助手(DatabaseConfigurationAssistant)用于建立數(shù)據(jù)庫(kù)、配置數(shù)據(jù)庫(kù)選項(xiàng)、刪除數(shù)據(jù)庫(kù)和管理模板。當(dāng)建立了acle數(shù)據(jù)庫(kù)之后，為了使得服務(wù)器端可以監(jiān)聽(tīng)該acle數(shù)據(jù)庫(kù)，必須配置監(jiān)聽(tīng)程序。為了使得客戶(hù)端可以訪問(wèn)該數(shù)據(jù)庫(kù)，必須在客戶(hù)端配置網(wǎng)絡(luò)服務(wù)名。只有合理地配置了監(jiān)聽(tīng)程序和網(wǎng)絡(luò)服務(wù)名之后，客戶(hù)應(yīng)用才能訪問(wèn)該數(shù)據(jù)庫(kù)。配置監(jiān)聽(tīng)程序和網(wǎng)絡(luò)服務(wù)名可以使用網(wǎng)絡(luò)管理工具M(jìn)anager完成。(源碼網(wǎng)整理：)1.1配置監(jiān)聽(tīng)程序配置