Insert value to table with for loop
SQL> CREATE TABLE myTable(
2 e INTEGER,
3 f INTEGER
4 );
Table created.
SQL>
SQL> begin
2 for i in 1..1000
3 loop
4 insert into myTable values(i, 56);
5 end loop;
6 end;
7 /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> drop table myTable;
Table dropped.
SQL>
Related examples in the same category