OraFAQ Forum: SQL & PL/SQL » XMLTYPE to CLOB

Home » SQL & PL/SQL » SQL & PL/SQL » XMLTYPE to CLOB (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

XMLTYPE to CLOB [message #438619]

Mon, 11 January 2010 04:02

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

I have 1 TEST1 table with col1 XMLTYPE column.
TEST2 table with col1 CLOBcomlumn

create table TEST1 (col1 XMLTYPE);

create table TEST2 (col1 CLOB);

I want to select from TEST1 table and store it into TEST2.
Please tell me how i can convert XMLTYPE to CLOB?

Thanks,

Report message to a moderator

Re: XMLTYPE to CLOB [message #438620 is a reply to message #438619]

Mon, 11 January 2010 04:09

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

INSERT INTO test2(col1)
SELECT to_clob(col1) from TEST1;

Report message to a moderator

Re: XMLTYPE to CLOB [message #438622 is a reply to message #438620]

Mon, 11 January 2010 04:36

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Jrowbottom`s suggestion is the one You required...In addition

Search for these...
1) getClobVal()
2) XMLDOM Package.
This One also helps you.

sriram.

Report message to a moderator