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
Printable View
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
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