ORA-00913 值太多 [英] ORA-00913 too many values

问题描述

我有这个查询

INSERT INTO hist_museum (SELECT * from of_owner.museum al
                                JOIN (SELECT vd.city_data_id 
                                        FROM of_owner.city_data vd 
                                        WHERE gps_full_date < add_months(SYSDATE,-12)) vd
                                    ON al.city_data_id = VD.city_data_id);

和表 hist_museum 和博物馆完全一样，但即使我得到这个错误:

and the tables hist_museum and museum are exactly the same, but even that I got this error:

Error(10,19): PL/SQL: ORA-00913: demasiados valores

推荐答案

通过select * from al JOIN ..."，您可以从 al 和您加入的子请求 vd 中获得所有值.你想要的是

With "select * from al JOIN ..." you get all values from al and your joined subrequest vd. What you want is

INSERT INTO hist_museum (SELECT al.* from of_owner.museum al
                            JOIN (SELECT vd.city_data_id 
                                    FROM of_owner.city_data vd 
                                    WHERE gps_full_date < add_months(SYSDATE,-12)) vd
                                ON al.city_data_id = VD.city_data_id);

这篇关于ORA-00913 值太多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！