Oracle inserts multiple data entries into one or more tables at a time.

Oracle needs to create two tables test1, test2: www.2cto.com create table test1 (id Integer primary key, name varchar2 (40 )); create table test2 (id integer primary key, age integer, height number); insert multiple data entries into a table at a time: SQL> insert all 2 into test1 values (1, 'A ') 3 into test1 values (2, 'bb ') 4 select * from dual; two rows have been created. Insert multiple data entries into multiple tables at a time: SQL> insert all 2 into test1 values (3, 'cc') 3 into test2 values (1, 2, 3) 4 select * from dual; two rows have been created.