Query to insert more than one record at a time in SQL

Table creation:

Table name: Customers

1. CREATE TABLE customers ( customer_no NUMBER,

                           customer_name VARCHAR2(100));

Insertion:

1. INSERT ALL

         INTO customers VALUES (2000, 'Sharma')

         INTO customers VALUES (2001, 'Saniya')

         INTO customers VALUES (2000, 'Mohan')

      SELECT * FROM DUAL;

Output:

 

 

Share: