|
WITH MONTH_DATA AS ( SELECT DECODE(MOD(ROWNUM, 3), 0, '강남점', 1, '역삼점', 2, '평촌점') AS SHOP_NM , TO_CHAR(ADD_MONTHS(TO_DATE('201401', 'YYYYMM'), ROUND(dbms_random.value(0,5),0)), 'YYYYMM') AS SALE_YM , ROUND(dbms_random.value( 1, 5000),0) AS PROFIT_AMT , ROUND(dbms_random.value(5000,10000),0) AS SALE_AMT FROM DUAL CONNECT BY LEVEL <= 25 ) SELECT * FROM ( SELECT SHOP_NM , SALE_YM , PROFIT_AMT FROM MONTH_DATA ) PIVOT (SUM(PROFIT_AMT) -- <-- 이곳에 컬럼을 지정 하지 않은 경우 FOR SALE_YM IN ('201401' -- <-- 이곳에 컬럼을 지정 하지 않은 경우 , '201402' , '201403' , '201404' , '201405' , '201406' ) );
|