OraFAQ Forum: JDeveloper, Java & XML » XML to Oracle Plsql Conversion

Home » Developer & Programmer » JDeveloper, Java & XML » XML to Oracle Plsql Conversion (Oracle 10g)

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

XML to Oracle Plsql Conversion [message #513216]

Fri, 24 June 2011 08:10

baskar.gouda@sun.com
Messages: 4
Registered: June 2009
Location: CHENNAI

Junior Member

Hi,
Does anybody know how to revert the following so that the output should be '<testPrice>1000</testPrice>'.

select htf.escape_sc('<testPrice>1000</testPrice>') from dual;
<testPrice>1000</testPrice>

Thanks-Bhaskar

Report message to a moderator

Re: XML to Oracle Plsql Conversion [message #513217 is a reply to message #513216]

Fri, 24 June 2011 08:15

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select '<testPrice>1000</testPrice>' from dual;

Regards
Michel

Report message to a moderator

Re: XML to Oracle Plsql Conversion [message #513222 is a reply to message #513217]

Fri, 24 June 2011 08:41

baskar.gouda@sun.com
Messages: 4
Registered: June 2009
Location: CHENNAI

Junior Member

Hi ,

I want to get <testPrice>1000</testPrice>
from '<testPrice>1000</testPrice>'
Thanks-Bhaskar Gouda

Report message to a moderator

Re: XML to Oracle Plsql Conversion [message #513225 is a reply to message #513222]

Fri, 24 June 2011 09:02

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no built-in function but there are many in different language on the web, you can easily find and convert them in PL/SQL.

Regards
Michel

Report message to a moderator

Re: XML to Oracle Plsql Conversion [message #513226 is a reply to message #513222]

Fri, 24 June 2011 09:05

Maaher
Messages: 7065
Registered: December 2001

Senior Member

DBMS_XMLGEN could help you out:

SQL> set define off
SQL> column data format a40
SQL> select dbms_xmlgen.convert('&lt;testPrice&gt;1000&lt;/testPrice&gt;'
  2                            , 1 -- dbms_xmlgen.ENTITY_DECODE
  3                            ) data
  4  from dual
  5  /

DATA
----------------------------------------
<testPrice>1000</testPrice>

Edit: correct reference to dbms_xml.ENTITY_DECODE.

[Updated on: Fri, 24 June 2011 09:07]

Report message to a moderator

Previous Topic:	Java Programs hang on startup
Next Topic:	Read XML Files!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 17:46:40 CST 2025