INSERT ALL

This allows you multiple inserts.

Step 1: Create table

create table mybuddy(name VARCHAR2(25),salary NUMBER);

table MYBUDDY created.

Step 2: Insert all

insert all INTO MYBUDDY(NAME,SALARY) VALUES ('Luke',7000)

           INTO MYBUDDY(NAME,SALARY) VALUES ('Henry',9500)

           INTO MYBUDDY(NAME,SALARY) VALUES ('Logan',3900)

           INTO MYBUDDY(NAME,SALARY) VALUES ('Benjamin',8000)

  SELECT * FROM dual;

4 rows inserted.