Insert value to table with for loop : Data Insert « PL SQL « Oracle PL / SQL






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

1.Use in parameter to pass value and insert value to a table
2.Data insert in a procedure
3.Insert data in procedure
4.Insert value passed in by parameter to a table
5.Insert value to a table after calculation
6.Insert value to product and productcategory with stored procedure
7.Insert a specified number of suppliers and products per supplier
8.Insert 100000 rows into a table with for loop
9.Loop through all to do a bulk insert
10.An anonymous block program to write the record to a row
11.This script demonstrates returning clause
12.Bulk insert with insert ... select
13.Hard code value and insert