PL/SQL
锛?/p>
Procedural Language/SQL
锛夋槸
Oracle
鍦ㄦ爣鍑?/p>
SQL
璇█涓婄殑杩囩▼鎬ф墿灞曘�?/p>
SQL
锛?/p>
Structure Query Language
锛?/p>
缁撴瀯鍖栨煡璇㈣瑷�锛?/p>
鏄簲鐢ㄧ▼搴忎笌鏁版嵁搴撹繘琛屼氦浜掓搷浣?/p>
鐨勬帴鍙ｃ�?/p>
灏嗘暟鎹煡璇?/p>
锛?/p>
Data Query
锛?/p>
銆?/p>
鏁版嵁鎿嶇旱
锛?/p>
Data Manipulation
锛?/p>
銆?/p>
鏁版嵁瀹氫箟
锛?/p>
Data Definition
锛?/p>
鍜屾暟鎹帶鍒讹紙
Data Control
锛夊姛鑳介泦浜庝竴浣撱�?/p>
SQL
鐨勭壒鐐癸細瀛楃鍊煎拰鏃ユ湡鍊煎尯鍒嗗ぇ灏忓啓銆傚綋鍦?/p>
SQL
璇彞涓紩鐢ㄥ瓧绗﹀�煎拰鏃ユ湡鍊兼椂锛?/p>
闇�瑕佺粰鍑烘纭殑澶у皬鍐欐暟鎹紝鍚﹀垯涓嶈兘杩斿洖姝ｇ‘鐨勪俊鎭�?/p>
PL/SQL
鐨勪緥瀛愶紝濡傛灉搴旂敤绋嬪簭闇�瑕佸彇寰楅泧鍛樼殑宸ヨ祫锛岄偅涔堝彲浠ュ缓绔嬪嚱鏁板疄鐜版敼鍔熻兘銆?/p>
Eg
锛?/p>
CREATE FUNCTION get_sal
锛?/p>
no NUMBER
锛?/p>
RETRUN NUMBER IS
Salary NUMBER
锛?/p>
6
锛?/p>
2
锛?/p>
BEGIN
SELECT sal INTO salary FROM emp WHERE empno=no
锛?/p>
RETURN salary
锛?/p>
END;
/
DECLARE
name varchar2(10);
BEGIN
SELECT ename INTO name FROM emp WHERE empno=&no;
Dbms_output.put_line(name);
EXCEPTION
WHEN NO_DA
TA_FOUND THEN
dbms_output.put_line(
鈥樿闆囧憳涓嶅瓨鍦ㄢ�?/p>
);
END;
/
PL/SQL
涓夌浣跨敤宸ュ叿鐨勪粙缁?/p>
绗竴绉嶏細
sqlplus
宸ュ叿
Sqlplus [username]/[password][@server]
鍏朵腑
username
鐢ㄤ簬鎸囧畾鏁版嵁搴撶敤鎴峰悕锛?/p>
password
鐢ㄤ簬鎸囧畾鐢ㄦ埛鍙ｄ护锛岃�?/p>
server
鍒欑敤浜?/p>
鎸囧畾涓绘満瀛楃涓诧紙缃戠粶鏈嶅姟鍚嶏級
銆傚綋閾炬帴鍒版湰鍦版暟鎹簱鏃讹紝涓嶉渶瑕佹彁渚涚綉缁滄湇鍔″悕銆?/p>
PL/SQL
鍧楃敱涓夐儴鍒嗙粍鎴愶細瀹氫箟閮ㄥ垎銆佹墽琛岄儴鍒嗐�佷緥澶栧鐞嗛儴鍒嗐�傚叾涓畾涔夐儴鍒嗙敤浜庡畾
涔夊父閲忋�佸彉閲忋�佹父鏍囥�佷緥澶栥�佸鏉傛暟鎹被鍨嬬瓑锛涙墽琛岄儴鍒嗙敤浜庡疄鐜板簲鐢ㄦā鍧楀姛鑳斤紝璇ラ儴鍒嗗寘
鍚簡瑕佹墽琛岀殑
PL/SQL
璇彞鍜?/p>
SQL
璇彞锛涗緥澶栧鐞嗛儴鍒嗙敤浜庡鐞嗘墽琛岄儴鍒嗗彲鑳藉嚭鐜扮殑杩愯
閿欒銆?/p>
DECLARE
璇ラ儴鍒嗘槸鍙�夌殑锛?/p>
/*
*/
BEGIN
璇ラ儴鍒嗘槸蹇呴』鐨勶紱
/*
*/
EXCEPTION
璇ラ儴鍒嗘槸鍙�夌殑
/*
*/
END
锛?/p>
瀹炰緥涓�锛氬彧鍖呭惈鎵ц閮ㄥ垎鐨?/p>
PL/SQL
鍧楋紱
Set serveroutput on