-- 错误的写法
insert into t_b_partner_vehicle(id, partner_id, vehicle_id)
(seq_t_b_partner_vehicle.nextval,121, (select id from t_b_car_info where org_id in(1441,1427)))
-- Error 单行子查询返回多行
-- 正确的写法
insert into t_b_partner_vehicle(id, partner_id, vehicle_id)
(select seq_t_b_partner_vehicle.nextval,121, id from t_b_car_info where org_id in(1441,1427))
oracle[insert 时报错: 单行子查询返回多行],布布扣,bubuko.com
原文:http://www.cnblogs.com/kyle-he/p/3835267.html