Oracle flexibly inserts data through query insert into... select..., oracle... select.
Insert into reg_user (id, name, password, area_code, reg_time, first_pswd, record_type) select l. reg_user_id, l. entry_person, '4qrcoum6wau + VuBX8g + IPg = ', l. area_code, sysdate, '20140901', l. type from location_info l where l. type = 5;
In the Oracle database, how do I insert records queried in the select statement into the database in batches?
Insert into B select * from;
Note: The query results must be consistent with the attribute columns of the table to be inserted.
For details, see hualong.javaeye.com/blog/692984.
Can I use Insertintoselect to insert blob fields in Oracle?
Yes, the time required for each query is certain. The query speed of the traversal table depends on the size of the data volume. If it is too large, it will have a time impact. If it is a very large database, and the requirements for data processing are particularly high, we can see that. There will be no big gap in general applications.