6 Replies Latest reply on Jun 19, 2012 12:18 PM by AlexAnd

    How to convert the sql query result into xml ? PLease..Please..

      I have a table Submission Record which contain a field with mix with text string and xml data type.

      Table name: Submission Record
      Field name: RCA
      Tom is a girl

      Its mixing with text and xml data.

      I wish to convert all into xml data as per request from management.

      my select statement is like below...but i think it may contain syntax error. Wish to get help from here.

      sqltestagain = "select '<DATA>' || RCA || '</DATA>' from Submission Record".

      Expect below will display



      or any other solution for it ??

      I've tried FOR XML....DBMS_XML......but none of it worked.....