oracle 查询插入

insert into tableName
(x1,x2,x3,x4,x5,x6)
select x1,
x2,
x3,
x4,
' 你好',
sysdate
from tableName1 t
where t.x1= 'x1_ss'

原文地址:https://www.cnblogs.com/Apeak/p/14736073.html