插入方式：
- 指定插入数据
insert into Z(a,b,c)values(1,2,3); - 指定插入数据
insert into Z(a,b,c) select 1,2,3 from dual; - 指定插入A表某一行数据
insert from Z(a,b,c) select d,e,f from A where id = 1;
jingwei129 2022-05-10 12:00 原文
插入方式：
insert into Z(a,b,c)values(1,2,3);insert into Z(a,b,c) select 1,2,3 from dual;insert from Z(a,b,c) select d,e,f from A where id = 1;