Tag:Batch insertion of data

  • Oracle’s Three Ways of Batch Insertion of Data [Recommendation]

    Time:2019-5-14

    The first is: begin insert into tableName(column1, column2, column3…) values(value1,value2,value3…); insert into tableName(column1, column2, column3…) values(value1,value2,value3…); insert into tableName(column1, column2, column3…) values(value1,value2,value3…); … end; Second species: insert into tableName(column1, column2, column3…) values(value1,value2,value3…); insert into tableName(column1, column2, column3…) values(value1,value2,value3…); insert into tableName(column1, column2, column3…) values(value1,value2,value3…); The third (using intermediate tables): Insert into tableName (column1 (primary key), […]