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

http://topic.csdn.net/t/20040818/16/3287013.html 
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS|AS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
˵Ã÷£ºisÒ²¿É»»³Éas
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;
  µ¥Ñ­»·£º
LOOP 
  statements
END LOOP;
//һֱѭ»·Óï¾ä¶Î,³ý·ÇÏÔʾµÄÊäÈëEXIT / EXIT WHEN Óï¾ä½áÊøÑ­»·
      
  WHILEÑ­»·£º
WHILE condition LOOP
    statements
END LOOP;
example:
  count:=0;
  WHILE counter<6 LOOP 
    count :=count + 1 ;
  END LOOP ;
5.for Ñ­»·
FOR loop_variable IN [REVERSE] lower_bound..upper_bound LOOP
  statements;
END LOOP;
example:
  FOR id IN 3..6 LOOP
  DBMS_OUTPUT.PUT_LINE(id);
  END LOOP;
6.±äÁ¿¸³Öµ
  V_TEST := 123;
  ±äÁ¿Ãû   ±äÁ¿ÀàÐÍ £»/ £º = [³õʼÊýÖµ] £»
id   INTEGER ;
  name   VARCHAR2(20) :='BinMing';
* proname product.price%TYPE ; // (%TYPE) ±íʾproname µÄÀàÐÍÒªºÍproduct±íÖеÄpriceµÄÀ