Pivot Table with Dynamic values
Naushad Bhamani, August 02, 2016 - 3:39 pm UTC
Thanks a bunch,
I can try this out. I really appreciate your help.
The decode in the link you provided helped me :)
Naushad Bhamani, August 05, 2016 - 4:06 pm UTC
SELECT TO_CHAR (a.end_time, 'dd') Day,
TO_CHAR (a.end_time, 'hh24') hr,
DECODE (
ROUND (
MAX (
DECODE (TO_CHAR (end_time, 'MM'),
TO_CHAR (ADD_MONTHS (SYSDATE, -1), 'MM'), a.maxval,
0)),
2),
0, NULL,
ROUND (
MAX (
DECODE (TO_CHAR (end_time, 'MM'),
TO_CHAR (ADD_MONTHS (SYSDATE, -1), 'MM'), a.maxval,
0)),
2))
prev_month,
DECODE (
ROUND (
MAX (
DECODE (TO_CHAR (end_time, 'MM'),
TO_CHAR (SYSDATE, 'MM'), a.maxval,
0)),
2),
0, NULL,
ROUND (
MAX (
DECODE (TO_CHAR (end_time, 'MM'),
TO_CHAR (SYSDATE, 'MM'), a.maxval,
0)),
2))
curr_month
FROM DBA_HIST_SYSMETRIC_SUMMARY a
WHERE a.metric_id IN (2121) AND maxval > 0 GROUP BY TO_CHAR (a.end_time, 'dd'), TO_CHAR (a.end_time, 'hh24') ORDER BY 1, 2