Repost of Xquery Solution
-
This is the repost as my code snippet was not formatted correctly. 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 74 174 And the above structure is taken in different ways for different purposes in project so i cannot change that DATA VALUE txtWeight 74 txtHeight 174 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
-
This is the repost as my code snippet was not formatted correctly. 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 74 174 And the above structure is taken in different ways for different purposes in project so i cannot change that DATA VALUE txtWeight 74 txtHeight 174 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