Posted on 2009-06-04 10:55
hanwei 阅读(203)
评论(1) 编辑 收藏 所属分类:
Oracle
CREATE OR REPLACE PROCEDURE myPro
(
ST_NUM IN NUMBER,
ED_NUM IN NUMBER
)
IS
BEGIN
declare
i number;
begin
FOR i IN ST_NUM..ED_NUM LOOP
INSERT INTO BASIC_CORP_SORT(BASIC_CORP_SORT_ID,BASIC_CORP_NAME) values(i,'你啊可能');
END LOOP;
end;
END;