SELECT value(q_tab).getClobVal() AS "XMLTYPE" FROM table(XMLSequence(Cursor(SELECT cal_h hierarchy, year_cd yr, year_id, s_date FROM (SELECT 'One' cal_h, 'FY2008' year_cd, 2008 year_id, '01-JAN-2008' s_date FROM DUAL UNION SELECT 'Two' cal_h, 'FY2008' year_cd, 2008 year_id, '01-APR-2008' s_date FROM DUAL UNION SELECT 'Three' cal_h, 'FY2008' year_cd, 2008 year_id, '01-JUL-2008' s_date FROM DUAL UNION SELECT 'Four' cal_h, 'FY2008' year_cd, 2008 year_id, '01-OCT-2008' s_date FROM DUAL) ))) q_tab;
69990