Sql querry for the difficult scenario

hi all,

I have one table in that only one column having data in xmlformat and remaing normal oracle datatypes.for example column name is xml_data.I need sql to get values from that xml data output data highlighted for reference in below xml data.


Sample xmldata for one of the record is like below

Please Login or Register  to view this content.

Requiredoutput:

xml_data

dsddd
qqqd

Attach (link) the xlm file as an external table
then run an import query to append the data to an internal table.