Pivot query using XML option in APEX
AD_PSAMay 10 2012 — edited Sep 8 2012Hi All..
I am using the following pivot query
with pivot_data as (
SELECT bdate,cat_code,no_of_ppl,agent_Code FROM test_table
)
select * from pivot_data
PIVOT XML (
SUM(no_of_ppl) FOR (agent_code) IN (select agent_code from tbl_agents )
)
order by bdate;
when i run it using apex SQL Workshop it gives the following output
BDATE CAT_CODE AGT_CODE_XML
01/01/2011 4 [unsupported data type]
01/01/2011 5 [unsupported data type]
01/01/2011 6 [unsupported data type]
01/01/2011 7 [unsupported data type]
what can b the reason of giving "unsupported data type" instead of the actual values;
Regards,
AD_PSA