Oracle BULK INSERT Data

Oracle BULK INSERT Data

Studied: http://blog.csdn.net/chenleixing/article/details/45165761/

Worship, quote the original:

So is there any other way?? The answer is yes, perhaps familiar with the Oracle database may know from the Oracle9i version later, you can use a method namely: "INSERT  all into a table values (each value) into  a table values (other values) into a table VALUES (Others) .... And then a SELECT statement ". Behind the SELECT statement we can look up from the virtual table as select 1 from DUAL. Note that the following SELECT statement can be arbitrary, but not the contents of the select out into the front table, but up to the front of the number of data each time inserting how many rows, this number of rows is and behind the SELECT statement to find out a few of the fixed, such as the following with the Select The statement found 15 records, then the front "INSERT  all into a" table values (each value 1) into  a table values (other values 2) into a table values (other values 3) " Insert a value of 1 for each field to insert 15 records, and then insert the value 2 for each corresponding field 15 records, and then insert the value 3 corresponding to each field 15 records.       we want to bulk insert multiple values such a record, so the back of the SELECT statement as long as can find a record on the line, it is recommended to use the back with select 1 from DUAL.

Add the test example later:

Oracle BULK INSERT Data