Hi Experts,
Could you please help me in Transposing Columns into Rows?
WITH T1 AS (
SELECT '511' ROOM, '1' ATTR1, '1' ATTR2, '1' ATTR3 FROM DUAL UNION ALL
SELECT '512' ROOM, '2' ATTR1, '0' ATTR2, '' ATTR3 FROM DUAL UNION ALL
SELECT '513' ROOM, '1' ATTR1, '3' ATTR2, '4' ATTR3 FROM DUAL UNION ALL
SELECT '514' ROOM, '1' ATTR1, '1' ATTR2, '3' ATTR3 FROM DUAL UNION ALL
SELECT '515' ROOM, '3' ATTR1, '4' ATTR2, '2' ATTR3 FROM DUAL UNION ALL
SELECT '516' ROOM, '2' ATTR1, '1' ATTR2, '' ATTR3 FROM DUAL UNION ALL
SELECT '517' ROOM, '' ATTR1, '4' ATTR2, '1' ATTR3 FROM DUAL)
SELECT * FROM T1
REQUIRED OUTPUT:
---------------
COUNT
ATTR1 10
ATTR2 14
ATTR3 11