[Solution] Oracle inserts multiple records at a time.

[Solution] multiple records must be written to the database when multiple records are inserted in Oracle at a time. The record set has been determined. If multiple records are inserted at a time, efficiency is bound to be affected. Solution:

Insert into tablename (col1, col2 ,...) select * from (select 'a1', 'a2 ',... from dual union all select 'a1', 'a2 ',... from dual union all select 'a1', 'a2 ',... from dual union all... select 'a1', 'a2 ',... from dual)

 

Note: There is no union all after the last select statement. Otherwise, an error is returned. Tests are performed only in the Oracle database. Test other databases on your own.