PL/SQL Insert

The Insert statement is part of Data Manipulation Language and  allows the user to insert a single record or multiple records into a table.

Syntax:

INSERT INTO table VALUES (value1, value2, value3, ...);
INSERT INTO table (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
INSERT INTO table1 (column1, column2) SELECT column1, column2 FROM table2;

Example 1:

INSERT INTO employees VALUES ('Steve', 20, 250);
INSERT INTO employees (name, dep_id, salary) VALUES ('David', 10, 300);

Example 2:

INSERT ALL
  INTO employees (name, dept_id, salary) VALUES ('Anne', 20, 250)
  INTO employees (name, dept_id, salary) VALUES ('George', 10, 200)
  INTO employees (name, dept_id, salary) VALUES ('Olivia', 40, 400)
SELECT * FROM dual;

Example 3:

INSERT INTO products(id, name, price)  SELECT id, name, price FROM old_products;