#DateForumTypeThreadPost
122 Feb 2016 @ 03:10 PSTGeneralReplyTrying to convert XML data into rows and columns using xmltable functionHi Pavan, I could get answer with the SQL below: SELECT X.* FROM (SELECT * FROM xml_test WHERE id=1) AS C, XMLTable (   '/linkCategories/linkCategory' PASSING c.xmldoc COLUMNS ...