Bind Variables

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;