ORA-01427 -通过之前的连接
ORA-01427 -通过之前的连接
提问于 2013-09-20 19:02:17
我有一个问题：
SELECT eo.mch_code, eo.mch_name, eo.serial_no, eo.category_id,
eo.sup_mch_code, eo.GROUP_ID, eo.cost_center,
(SELECT e1.sup_mch_code
FROM equipment_object e1
WHERE e1.sup_mch_code LIKE 'OBIEKT-S/%'
CONNECT BY PRIOR e1.sup_mch_code = e1.mch_code
START WITH e1.mch_code = eo.mch_code) obiekt_s_kod,
(SELECT e2.mch_name
FROM equipment_all_object e2
WHERE e2.mch_code =
(SELECT e1.sup_mch_code
FROM equipment_object e1
WHERE e1.sup_mch_code LIKE
'OBIEKT-S/%'
CONNECT BY PRIOR e1.sup_mch_code =
e1.mch_code
START WITH e1.mch_code = eo.mch_code)) obiekt_s_nazwa
FROM equipment_object eo
WHERE eo.contract LIKE NVL (UPPER ('&umiejscowienie'), '%')
AND eo.mch_code LIKE NVL (UPPER ('&obiekt_podrzedny'), '%')
AND NVL (eo.cost_center, ' ') LIKE NVL (UPPER ('&MPK'), '%')
CONNECT BY PRIOR eo.mch_code = eo.sup_mch_code
START WITH eo.sup_mch_code LIKE UPPER ('&obiekt_nadrzedny')但是当我编译这个查询时，我得到了错误：
ORA-01427: single-row subquery returns more than one row哪里是错误?？我读了很多话题，但我不会搜索我的问题
回答 1
Stack Overflow用户
发布于 2013-09-20 19:32:17
Ok，我解决了这个问题:)！
我必须插入条件: rownum =1
示例如下：
SELECT eo.mch_code, eo.mch_name, eo.serial_no, eo.category_id,
eo.sup_mch_code, eo.GROUP_ID, eo.cost_center,
(SELECT e1.sup_mch_code
FROM equipment_object e1
WHERE e1.sup_mch_code LIKE 'OBIEKT-S/%'
and rownum=1
CONNECT BY PRIOR e1.sup_mch_code = e1.mch_code
START WITH e1.mch_code = eo.mch_code) obiekt_s_kod,
(SELECT e2.mch_name
FROM equipment_all_object e2
WHERE e2.mch_code =
(SELECT e1.sup_mch_code
FROM equipment_object e1
WHERE e1.sup_mch_code LIKE
'OBIEKT-S/%'
and rownum=1
CONNECT BY PRIOR e1.sup_mch_code =
e1.mch_code
START WITH e1.mch_code = eo.mch_code)) obiekt_s_nazwa
FROM equipment_object eo
WHERE eo.contract LIKE NVL (UPPER ('&umiejscowienie'), '%')
AND eo.mch_code LIKE NVL (UPPER ('&obiekt_podrzedny'), '%')
AND NVL (eo.cost_center, ' ') LIKE NVL (UPPER ('&MPK'), '%')
CONNECT BY PRIOR eo.mch_code = eo.sup_mch_code START WITH eo.sup_mch_code LIKE UPPER ('&obiekt_nadrzedny')页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/18915170
复制相关文章
相似问题
腾讯云开发者
