1、过程主体
--存储过程循环 ,SELECT INTO 是隐式游标只能返回一行 CREATE OR REPLACE PROCEDURE P_LOOP_PR ( P_TIME NUMBER) IS A_OVER NUMBER; A_NAME VARCHAR2(20); BEGIN FOR I IN 1..10 LOOP SELECT A.PRODUCT_NUM*A.PRODUCT_NUM,A.PRODUCT_NAME INTO A_OVER,A_NAME FROM PRODUCT_RELEASE A WHERE A.PUT_TIME=P_TIME ORDER BY A.PRODUCT_ID; DBMS_OUTPUT.PUT_LINE('商品名称:'||A_NAME||',