注册

使用递归语句同时更新两个字段报错,语法与oracle不兼容

Zren.C 2025/04/30 83 3

使用递归语句同时更新两个字段报错,语法与oracle不兼容
样例sql:
UPDATE RP_ADDRESS X
SET (X.ADDRESS_ID_7, X.OLD_SYS_ID_7) =
(SELECT B.ID, B.OLD_SYS_ID FROM RM_ADDRESS B WHERE B.ADDRESS_TYPE_ID = 80526995 AND ROWNUM = 1 CONNECT BY NOCYCLE PRIOR B.PARENT_ID = B.ID START WITH B.ID = X.ID)

第158 行附近出现错误[-2274]:WITH FUNCTION转换失败
image.png

回答 0
暂无回答
扫一扫
联系客服