Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to update xml type from blob type?

how to update xml type from blob type?

From: Aakash <bordia_at_gmail.com>
Date: 12 May 2006 14:58:21 -0700
Message-ID: <1147471101.449063.158720@u72g2000cwu.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US