下面这个语句是对的,可以选中一批数据,
select
t.target_id,
t.first_name,
l.DESCRIPTION,
i.information_id
from
targets t
inner join
locations l
on
t.location_id= l.location_id
inner join
information i
on
t.target_id = i.target_id;
我想把选中的这些数据插入另外一张表:
insert into targets_information
select
t.target_id,
t.first_name,
l.DESCRIPTION,
i.information_id
from
targets t
inner join
locations l
on
t.location_id= l.location_id
inner join
information i
on
t.target_id = i.target_id;就报错了,错误提示是:
l.DESCRIPTION,
*ERROR at line 5:
ORA-01722: invalid number 请问有高手帮我看看可能是什么问题么? 表的字段足够长了。
select
t.target_id,
t.first_name,
l.DESCRIPTION,
i.information_id
from
targets t
inner join
locations l
on
t.location_id= l.location_id
inner join
information i
on
t.target_id = i.target_id;
我想把选中的这些数据插入另外一张表:
insert into targets_information
select
t.target_id,
t.first_name,
l.DESCRIPTION,
i.information_id
from
targets t
inner join
locations l
on
t.location_id= l.location_id
inner join
information i
on
t.target_id = i.target_id;就报错了,错误提示是:
l.DESCRIPTION,
*ERROR at line 5:
ORA-01722: invalid number 请问有高手帮我看看可能是什么问题么? 表的字段足够长了。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货