例如我要向表(dept)中插入两条数据,必须要用两次insert into 吗?能不能只用一次insert into,网上百度的好多办法都不行,那位大神可以帮忙解答一下啊,谢谢!
insert into dept(deptno,dname,loc)values(10,'accounting','new york');
insert into dept (deptno,dname,loc) values(20,'research','dallas');
...全文
8253打赏收藏
用sql developer如何插入多条数据
例如我要向表(dept)中插入两条数据,必须要用两次insert into 吗?能不能只用一次insert into,网上百度的好多办法都不行,那位大神可以帮忙解答一下啊,谢谢! insert into dept(deptno,dname,loc)values(10,'accounting','new york'); insert into dept (deptno,dname,loc) values(20,'research','dallas');
with tmp as
(
select 10 deptno, 'accounting' dname, 'new york' loc from dual
union all
select 20 deptno, 'research' dname, 'dallas' loc from dual
)
insert into dept(deptno,dname,loc) select * from tmp;