I have the following query

SELECT *
FROM (SELECT 1 Cnt, TO_NUMBER (TO_CHAR (A.Hiredate, 'YYYY')) Yr
FROM Emp A)
PIVOT xml
(SUM (Cnt) FOR Yr IN (any))

However I want to convert the XML which can have a variable number of columns into a readable format. I know that I can use XMLTABLE but it requires that you already know the number of columns. Is there any technique or option to allow me to do this?

Is there any plans to add the "any" clause into a standard pivot command so you could do something like

SELECT *
FROM (SELECT 1 Cnt, TO_NUMBER (TO_CHAR (A.Hiredate, 'YYYY')) Yr
FROM Emp A)
PIVOT
(SUM (Cnt) FOR Yr IN (any))

Thanks for any help you can give me.