Example:
1 2 3 4 5 6 7 |
DECLARE ln_num NUMBER (10); BEGIN FOR i IN 1 .. 10000 LOOP EXECUTE IMMEDIATE 'SELECT :b FROM DUAL' INTO ln_num USING i; END LOOP; END; |
Example:
1 2 3 4 5 6 7 |
DECLARE ln_num NUMBER (10); BEGIN FOR i IN 1 .. 10000 LOOP EXECUTE IMMEDIATE 'SELECT :b FROM DUAL' INTO ln_num USING i; END LOOP; END; |