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