【正文】 1 / 27文件標識：QD3008 密級：內部版本號：大慶金橋軟件開發(fā)作業(yè)體系Oracle 數據庫命名編碼規(guī)范1 / 27變更歷史操作 責任人 日期 版本 變更內容創(chuàng)建 李富華 20220420 無 創(chuàng)建文檔編輯 周強 20220421 無 修改文檔2 / 27目錄1. 文檔介紹 ..............................................................................................................................4 文檔目的 .........................................................................................................................................4 文檔范圍 .........................................................................................................................................4 定義 .................................................................................................................................................4 參考資料 .........................................................................................................................................42. 命名規(guī)范 ..............................................................................................................................4 一般規(guī)則 .........................................................................................................................................4 對象命名匯總表 .............................................................................................................................53. 編碼規(guī)范 ..............................................................................................................................6 一般性規(guī)定 .....................................................................................................................................6 CREATE 語句 .................................................................................................................................7 SELECT 語句 .................................................................................................................................7 INSERT 語句 ..................................................................................................................................8 UPDATE 語句 ................................................................................................................................8 DELETE 語句 .................................................................................................................................9 游標語句 .........................................................................................................................................9 IF 語句 .............................................................................................................................................9 簡單循環(huán)語句 ...............................................................................................................................11 FOR 循環(huán)語句 ..............................................................................................................................11 WHILE 循環(huán)語句 .........................................................................................................................11 程序塊規(guī)范 ...................................................................................................................................12 語法規(guī)范 .......................................................................................................................................124. 設計規(guī)范 ............................................................................................................................14 一般表設計 ...................................................................................................................................14 特殊表設計原則 ...........................................................................................................................15 索引設計原則 ...............................................................................................................................15 完整性設計原則 ...........................................................................................................................15 觸發(fā)器 ...........................................................................................................................................15 視圖設計 .......................................................................................................................................15 性能優(yōu)化 .......................................................................................................................................165. 書寫規(guī)范 ............................................................................................................................20 縮進風格 ..........................................................