Xquery solution needed
-
I have got a field in a table which is of xmltype, say file_block the data for the same is structured as shown below data type="Structure"> control id="txtWeight"> value>74/value> /control> control id="txtHeight"> value>174/value> control> /data> (I have removed the '<' tags from the xml code as codeproject is only taking the content 174 and 74 only while removing all other codes as they are treating the code as a formatted one... So please read my code by prepending the appropriate line with '<') Now I want to retrieve the values from it as follows Data Value txtWeight 74 txtHeight 174 And the above structure is taken in different ways for different purposes in project so i cannot change that. Now how could i retrieve the data as a tabular structure as shown above using xquery. Please help if anyone know how to do that.