1 Reply Latest reply on Jan 6, 2014 8:58 AM by Karthick2003

    How to parsing xml data in sql statement??

    krishnagopi614

      Hi friends, I have a table which contain column as clob ,stores in xml format, for example my column contain xml data like this

      <Employees xmlns="http://TargetNamespace.com/read_emp">
         <C1>106</C1>
         <C2>Harish</C2>
         <C3>1998-05-12</C3>
         <C4>HR</C4>
         <C5>1600</C5>
         <C6>10</C6>
      </Employees>
      
      

       

        Then how to extract the data in above xml column data using SQL statement...