如題，
INSERT INTO LATESTACTREPAY
SELECT LOAN_UUID, RO, FACT_DATE, FACT_SK_MONEY
FROM (SELECT A.LOAN_UUID,
ROW_NUMBER() OVER(PARTITION BY A.LOAN_UUID ORDER BY C.FACT_DATE DESC) AS RO,
FACT_DATE,
SUM(FACT_SK_MONEY) FACT_SK_MONEY
FROM ENFO_EPM.QLC_TCONTRACT_LOAN@ENFO A
LEFT JOIN ENFO_EPM.QLC_TINAPPLY@ENFO B ON A.LOAN_UUID = B.LOAN_UUID
LEFT JOIN ENFO_EAM.EAM_TINAPPLY_LEFT@ENFO C ON B.IN_UUID = C.IN_UUID
GROUP BY A.LOAN_UUID, FACT_DATE)
WHERE RO = 1
如上陳述句，只有講查詢中的排序欄位去掉，才不會報錯，不去掉就會ORA-22992: 無法使用從遠程表選擇的 LOB 定位符
這是什么原因？大神們
uj5u.com熱心網友回復：
大神們！救助！！轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/267715.html
標籤：基礎和管理