How can Oracle insert multiple records in a batch?

In Oracle database, you can use the INSERT ALL statement to insert multiple rows of data in bulk. Here is an example:

INSERT ALL
INTO table_name (column1, column2) VALUES (value1_1, value1_2)
INTO table_name (column1, column2) VALUES (value2_1, value2_2)
INTO table_name (column1, column2) VALUES (value3_1, value3_2)
SELECT * FROM dual;

In the example above, table_name is the name of the table where the data will be inserted, column1 and column2 are the names of the columns where the data will be inserted, and value1_1, value1_2, value2_1, value2_2, etc. are the specific values to be inserted.

By using the INSERT ALL statement, it is possible to insert multiple rows of data at once, thereby increasing the efficiency of data insertion.