Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

converting varchar2 to xmltype

767841Apr 20 2010 — edited Apr 20 2010
Hi,
Is there any way to convert a varchar2 column to xmltype in a sql statement
I want to retrieve valule from a xml fragment in a sql statement(not pl/sql). but xml fragment is stored in a varchar2 column.

SELECT value(List).extract('/@count').getNumberVal()
FROM test1temp x, table(XMLSequence(x.(*converted xmltype to be here from varchar2 column of table test1temp*).extract('/Product'))) List

Edited by: user13011984 on Apr 20, 2010 2:52 AM
This post has been answered by BoopathiL on Apr 20 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2010
Added on Apr 20 2010
#xml
4 comments
30,586 views