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åæ¥è°è¯èå±
温馨提示:答案为网友推荐,仅供参考