Posted on 2009-11-07 13:15
leekiang 閱讀(283)
評論(0) 編輯 收藏 所屬分類:
oracle
CREATE OR REPLACE PROCEDURE p_test(ST_NUM IN NUMBER, /*起始數值*/
?????????????????????????????????? ED_NUM IN NUMBER /*結束數值*/) IS
BEGIN
? declare
??? i number;
? begin
??? /*循環插入*/
??? FOR i IN ST_NUM .. ED_NUM LOOP
????? INSERT INTO test_temp values (i, 'test');
??? END LOOP;
? end;
? commit;
? /*異常處理*/
EXCEPTION
? WHEN OTHERS THEN
??? rollback;
END;
在command window里執行call p_test(1,100);