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;