Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> how to update xml type from blob type?
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 Fri May 12 2006 - 16:58:21 CDT