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; |
TOOLS
POSTS
-
|
|
|
|
|
|
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; |
|
|