oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ìõ
  ¼Ç¼£¬·ñÔòÅ׳öÒì³£(Èç¹ûûÓмǼÅ׳öNO_DATA_FOUND)
  Àý×Ó£º
  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.±äÁ¿¸³Öµ
  V_TEST := 123;
6.ÓÃ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;
END LOOP;
  END;
7.´ø²ÎÊýµÄcursor
  CURSOR C_USER(C_ID NUMBER) IS SELECT NAME from USER WHERE TYPEID=C_ID;
  OPEN C_USER(±äÁ¿Öµ);
  LOOP
FETCH C_USER INTO V_NAME;
EXIT FETCH C_USER%NOTFOUND;
    do something
  END LOOP;
  CLOSE C_USER;
8.ÓÃpl/sql developer debug
  Á¬½ÓÊý¾Ý¿âºó½¨Á¢Ò»¸öTest WINDOW
  ÔÚ´°¿ÚÊäÈëµ÷ÓÃSPµÄ´úÂë,F9¿ªÊ¼debug,CTRL+Nµ¥²½µ÷ÊÔ