Oracle Sql 循环

Oracle Sql 循环

 

Declare 
Lcntr number; 
Begin 
FOR Lcntr IN 1..5
LOOP 
     DBMS_OUTPUT.PUT_LINE('Lcntr='||Lcntr);
END LOOP; 
end;

 

Begin 
FOR REC_INIT IN (select HZ_NAME from HZ) LOOP
    DBMS_OUTPUT.PUT_LINE(hz='||REC_INIT.ID);
END LOOP;

end;