1.
鍩烘湰缁撴瀯
create OR REPLACE PROCEDURE
瀛樺偍杩囩▼鍚嶅瓧
(
鍙傛暟
1 IN NUMBER,
鍙傛暟
2 IN NUMBER
) IS
鍙橀噺
1 INTEGER :=0;
鍙橀噺
2 DATE;
BEGIN
END
瀛樺偍杩囩▼鍚嶅瓧
2.select INTO STA
TEMENT
灏?/p>
select
鏌ヨ鐨勭粨鏋滃瓨鍏ュ埌鍙橀噺涓紝
鍙互鍚屾椂灏嗗涓垪瀛樺偍澶氫釜鍙橀噺涓紝蹇呴』鏈変竴鏉¤
褰曪紝鍚﹀垯鎶涘嚭寮傚父
(
濡傛灉娌℃湁璁板綍鎶涘嚭
NO_DATA_FOUND)
渚嬪瓙锛?/p>
BEGIN
select col1,col2 into
鍙橀噺
1,
鍙橀噺
2 FROM typestruct where xxx;
EXCEPTION
WHEN NO_DATA_FOUND THEN
xxxx;
END;
...
3.IF
鍒ゆ柇
IF V_TEST=1 THEN
BEGIN
do something
END;
END IF;
4.while
寰幆
WHILE V_TEST=1 LOOP
BEGIN
XXXX
END;
END LOOP;
5.
鍙橀噺璧嬪�?/p>
V_TEST := 123;
6.
鐢?/p>
for in
浣跨敤
cursor
...
IS
CURSOR cur IS select * FROM xxx;
BEGIN
FOR cur_result in cur LOOP
BEGIN
V_SUM :=cur_result.
鍒楀悕
1+cur_result.
鍒楀悕
2
END;