Oracle XML getClobVal()
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;


Oracle XML getClobVal()

Oracle registered trademark of Oracle Corporation.

Last Revised On: 07/30/2014

  69990