如何在11g中插入多个值？

How to insert multiple values in a table in oracle 11g using query?

如何使用查询在oracle 11g中的表中插入多个值?

I tried This

我试过这个

1 个解决方案

#1

Use the following DML known as INSERT ALL statement :

使用以下称为INSERT ALL语句的DML:

insert all into departmentstrigger values(4,'Hello') 
           into departmentstrigger values(5,'HEy There')
           into departmentstrigger values(6,'sup')
           into departmentstrigger values(7,'Hii')
  select * from dual;

SQL Fiddle Demo

SQL小提琴演示

For a detailed explanation you may look at : Insert All Statement

有关详细说明,请参阅:插入所有声明

#1