BREAK ON MONTH SKIP 1
COLUMN MONTH 20
SET LINESIZE 120
 
SELECT LPAD( Month, 20-(20-LENGTH(month))/2 ) month,
"SON", "MON", "DIN", "MIT", "DON", "FRE", "SAM"
FROM (
SELECT
TO_CHAR(dt,'fmMonthfm YYYY') month,
TO_CHAR(dt+1,'iw') week,
MAX(DECODE(TO_CHAR(dt,'d'),'1',LPAD(TO_CHAR(dt,'fmdd'),2)))
"SON",
MAX(DECODE(TO_CHAR(dt,'d'),'2',LPAD(TO_CHAR(dt,'fmdd'),2)))
"MON",
MAX(DECODE(TO_CHAR(dt,'d'),'3',LPAD(TO_CHAR(dt,'fmdd'),2)))
"DIN",
MAX(DECODE(TO_CHAR(dt,'d'),'4',LPAD(TO_CHAR(dt,'fmdd'),2)))
"MIT",
MAX(DECODE(TO_CHAR(dt,'d'),'5',LPAD(TO_CHAR(dt,'fmdd'),2)))
"DON",
MAX(DECODE(TO_CHAR(dt,'d'),'6',LPAD(TO_CHAR(dt,'fmdd'),2)))
"FRE",
MAX(DECODE(TO_CHAR(dt,'d'),'7',LPAD(TO_CHAR(dt,'fmdd'),2)))
"SAM"
FROM ( SELECT TRUNC(SYSDATE,'y')-1+ROWNUM dt
FROM all_objects
WHERE ROWNUM <= ADD_MONTHS(TRUNC(SYSDATE,'y'),12) -
TRUNC(SYSDATE,'y')
)
GROUP BY TO_CHAR(dt,'fmMonthfm YYYY'), TO_CHAR( dt+1, 'iw' )
)
ORDER BY TO_DATE( month, 'Month YYYY' ), TO_NUMBER(week);