Oracle executes SQL file scripts and inserts or updates data in batches.

In the past, I remember that Mysql Command terminals can insert or update databases in batches.
 
Write down the PL/SQL Deverloper Method for Batch Data Processing today.
 
1. log on to PL/SQL Developer
2. Choose menu File> New> command window.
3, SQL> @ d: \ d. SQL (in the test. SQL file on disk d, the file contains the SQL statement you want to execute)
 
The script file format can be as follows:

1 set serveroutput on;
2 whenever oserror exit failure rollback;
3 whenever sqlerror exit failure rollback;
4
5/* here is your remark ····*/
6
7 inserter...
8
9 update...
10
11 ····
12
13
14 COMMIT;
 

:




Author: Hemingway