오라클 버젼 9.2.0.4
Select 할때 적용한 컬럼이 21인데요.
17개 까지는 잘 나오다가 그이상이 되면 ORA-01467 sort key too long
라는 메세지가 나옵니다
select CEIL(NO/21),
MAX(DECODE(MOD(NO,21),1,컬럼)) F01
MAX(DECODE(MOD(NO,21),2,컬럼)) F02
MAX(DECODE(MOD(NO,21),3,컬럼)) F03
.........
MAX(DECODE(MOD(NO,21),21,컬럼)) F21
FROM (
SELECT ROWNUM NO, Y.컬럼
FROM A.테이블 X
( SELECT COL S FROM B )
UNION ALL
( SELECT COL FROM B )
UNION ALL
( SELECT COL FROM B )
......
UNION ALL
( SELECT COL FROM B ) 21개
) Y
WHERE X.COL1=Y.COL
GROUP BY CEIL(NO/21)
도와주세요~~~
|