Oracle Insert All | Insert All - oracle tutorial - sql tutorial



What is INSERT ALL statement in oracle ?

  • The Oracle INSERT ALL statement is used to add multiple rows with a single INSERT statement. The rows can be inserted into one table or multiple tables using only one SQL command.

Syntax

INSERT ALL
  INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
  INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
  INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
SELECT * FROM dual;
click below button to copy the code. By - oracle tutorial - team
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

Parameters or Arguments

mytable

  • The table to insert the records into

column1, column2, column_n

  • The columns in the table to insert values

expr1, expr2, ... expr_n

  • The values to assign to the columns in the table

Example:

INSERT ALL
  INTO wikitechy_emp (Id,Name,Position,City) VALUES (6,'Asha','Admin','Dindugal')
 INTO wikitechy_emp (Id,Name,Position,City) VALUES (7,'Geetha','Tester','Trichy')
  INTO wikitechy_emp (Id,Name,Position,City) VALUES (8,'Kavitha','Tester','Chennai')
SELECT * FROM dual;
click below button to copy the code. By - oracle tutorial - team

Screenshot:

 insert employee table
  1. Before the execution of the table , the rows of wikitechy_emp table will be like this as shown above
 ibefore execution of employee table
  1. By using the “Insert All” query , we can able to insert any number of rows in the table (Here our table name is wikitechy_emp) at a single query insert statement.
  2. Clicking on the Run button the query will executed .
  3. We can see the rows which has been successfully inserted in the wikitech_emp table.
 output emptable of employee table
  1. After the QUERY Execution the table “wikitechy_emp” will be displayed in this way by adding the additional rows a shown above.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to Oracle Insert All | Insert All