XML SQL extract

[irehman]

Hello,

In one column, there is a xml doc stored in the table. I need to write a sql to extract that data, How do I do that?

I never worked with XML stored docs.

Thanks in Advance

[RBARAER]

Have a look at the XMLType datatype, and then have a look at Querying XML Content Stored in Oracle XML DB, I think that should be of some help . I must admit I don't use XML very often.

HTH & Regards,

rbaraer