发表于 2009-1-5 19:48
| 
Oracle PL/SQL鍏ラ棬涔嬫叏杩--(2)
鍙戝竷: 2008-12-05 15:46 | 浣滆: 缃戠粶杞浇 | 鏉ユ簮: 缃戠粶杞浇 | 鏌ョ湅: 15娆
銆銆PL/SQL绋嬪簭娈典腑鏈変笁绉嶇▼搴忕粨鏋勶細鏉′欢缁撴瀯銆佸惊鐜粨鏋勫拰椤哄簭缁撴瀯銆
銆銆 鏉′欢缁撴瀯
銆銆涓庡叾瀹冭瑷瀹屽叏绫讳技锛岃娉曠粨鏋勫涓嬶細
if condition then
statement1
else
statement2
end if ;
銆銆 寰幆缁撴瀯
銆銆杩欎竴缁撴瀯涓庡叾浠栬瑷涓嶅お涓鏍凤紝鍦≒L/SQL绋嬪簭涓湁涓夌寰幆缁撴瀯锛
a. loop 鈥 end loop;
b. while condition loop 鈥 end loop;
c. for variable in low_bound . . upper_bound loop 鈥 end loop;
銆銆鍏朵腑鐨勨溾︹濅唬琛ㄥ惊鐜綋銆
銆銆 椤哄簭缁撴瀯
銆銆瀹為檯灏辨槸goto鐨勮繍鐢紝涓嶈繃浠庣▼搴忔帶鍒剁殑瑙掑害鏉ョ湅锛屽敖閲忓皯鐢╣oto鍙互浣垮緱绋嬪簭缁撴瀯鏇村姞鐨勬竻鏅般
銆銆4銆丼QL鍩烘湰鍛戒护
銆銆PL/SQL浣跨敤鐨勬暟鎹簱鎿嶄綔璇█杩樻槸鍩轰簬SQL鐨勶紝鎵浠ョ啛鎮塖QL鏄繘琛孭L/SQL缂栫▼鐨勫熀纭銆傝〃锛-1涓篠QL璇█鐨勫垎绫汇
銆銆琛1-1銆SQL璇█鍒嗙被
绫诲埆 SQL璇彞
鏁版嵁瀹氫箟璇█(DDL) Create ,Drop,Grant,Revoke, 鈥
鏁版嵁鎿嶇旱璇█(DML) Update,Insert,Delete, 鈥
鏁版嵁鎺у埗璇█(DCL) Commit,Rollback,Savapoint, 鈥
鍏朵粬 Alter System,Connect,Allocate, 鈥
銆銆鍙互鍙傞槄鍏朵粬鍏充簬SQL璇█鐨勮祫鏂欐潵浜嗚В鍏蜂綋鐨勮娉曠粨鏋勶紝杩欓噷灏变笉澶氳禈杩颁簡銆
