Hi

I just want to confirm one thing if anybody can help me out.

Is it possible to insert multiple rows simultaneously into a table without using select statement. Like when we create a new table and we hav to enter 100 records. Do we hav to write INSERT INTO statement 100 times ?



I'll be very thankful if anybody can resolve my problem.

INSERT INTO table_name
SELECT field1, field2
FROM another_table
WHERE your_condition_from_subquery

use sqlloader or external tables

SQL> CREATE TABLE x (a NUMBER);

Table created.

SQL> BEGIN
2 FOR i IN 1..10 LOOP
3 INSERT INTO x VALUES (i);
4 END LOOP;
5 END;
6 /

PL/SQL procedure successfully completed.

SQL> select * from x;

A
----------
1
2
3
4
5
6
7
8
9
10

10 rows selected.

SQL>