For loops in Oracle

DECLARE   Str Varchar(Ten);--define a string variable strBEGIN    forIinch 1..10000000Loop-- INSERT into Fw_test (NAME) VALUES (' BBB ' + i);D ecode (' 1 ', ', ', ', ' DECODE ', ' 2 ', ', ', ', ' DECODE ', ' 3 ', ', ', ' 2 ' | | ' 3 '))) NVL2 (' 1 ', NVL2 (' 2 ', NVL2 (' 3 ', ' 2 ' | | 3 ', '), ')      SELECTDECODE ('1',"',"', DECODE ('2',"',"', DECODE ('3',"',"','2'||'3'))) as Str  into Str  fromDual--assign the value of the query to STRSys.dbms_output.put_line (Str ||i);--Print the string   EndLoop; Commit;END;/

Because there are too many loops, the SQL statement needs to be executed first on the command line:

Set   Serveroutput on      size   10000000

For loops in Oracle