【正文】 ........7 INSERT 語句 ..................................................................................................................................8 UPDATE 語句 ................................................................................................................................8 DELETE 語句 .................................................................................................................................9 游標(biāo)語句 .........................................................................................................................................9 IF 語句 .............................................................................................................................................9 簡單循環(huán)語句 ...............................................................................................................................11 FOR 循環(huán)語句 ..............................................................................................................................11 WHILE 循環(huán)語句 .........................................................................................................................11 程序塊規(guī)范 ...................................................................................................................................12 語法規(guī)范 .......................................................................................................................................124. 設(shè)計規(guī)范 ............................................................................................................................14 一般表設(shè)計 ...................................................................................................................................14 特殊表設(shè)計原則 ...........................................................................................................................15 索引設(shè)計原則 ...............................................................................................................................15 完整性設(shè)計原則 ...........................................................................................................................15 觸發(fā)器 ...........................................................................................................................................15 視圖設(shè)計 .......................................................................................................................................15 性能優(yōu)化 .......................................................................................................................................165. 書寫規(guī)范 ............................................................................................................................20 縮進(jìn)風(fēng)格 .......................................................................................................................................20 空格及換行 ...................................................................................................................................206. 注釋說明 ............................................................................................................................21 一般性注釋 ...................................................................................................................................213 / 27 函數(shù)文本注釋 ...............................................................................................................................217. 異常規(guī)范 ............................................................................................................................22 PL/SQL 異常規(guī)范 ...........................................................................................................................22 后臺驗證異常信息規(guī)范 ...............................................................................................................238. 附錄 ....................................................................................................................................23 附一 開發(fā)工具 .............................................................................................................................23 附二 預(yù)定義異常 .........................................................................................................................24 附三 范式 .....................................................................................................................................25 第一范式 ...............................................................................................................................25 第二范式 ...........................................................................................................