DBILITY

MERGE 사용시 0901오류 발생 SQL0901: SQL system error. Cause . . . . . : An SQL system error has occurred. The current SQL statement cannot be completed successfully. The error will not prevent other SQL statements from being processed. Previous messages may indicate that there is a problem with the SQL statement and SQL did not correctly diagnose the error. The previous message identifier was CPF4204. ..

전년도(2015)에 database.sarang.net에 답변해 드린 내용입니다. 지금보니 내가 한게 맞는지 의문이 들고 있음. 11G부터는 PIVOT을 지원합니다. WITH A(NO,COUNT,LOWER_BND) AS ( SELECT 'A001',1,80 FROM DUAL ), B(NO,COUNT,I_NO,AMT) AS ( SELECT 'A001',1,1,1000 FROM DUAL UNION ALL SELECT 'A001',1,2,3000 FROM DUAL ), C(NO,COUNT,SEQ,VENDOR,AMT) AS ( SELECT 'A001',1,1,'A1',3000 FROM DUAL UNION ALL SELECT 'A001',1,1,'A2',1000 FROM DUAL UNION ALL SELECT '..