Re: how to update xml type from blob type?

hey,
XMLType has a constructor which takes in a CLOB. So if you can convert your BLOB to a CLOB u are done. Not sure if XDB has a direct way to convert from BLOB to XMLType.

--Rajesh.
Aakash wrote:
> Hi Guys, we have XML documents stored in BLOB column. And trying to
> convert them to XML data type. We need to do something like this:
>
> insert into o1(xmltype) select blob from o2;
>
> What conversion functions should we use?
>
> Thanks
Received on Mon May 15 2006 - 01:28:18 CDT