Example:
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:
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;