sql - How to Convert the converted HTML tags back to the actual HTML Content -


i'm converting html tags xml using "dbms_xmlgen.convert" funciton. ex:-

original html text:-

<p style="margin-bottom: 0pt;"><font color=#000080 size=2><font color=#000080 size=2> 

converting xml :-

select dbms_xmlgen.convert('<p style="margin-bottom: 0pt;"><font color=#000080 size=2><font color=#000080 size=2>') dual 

output:-

<p style=&quot;margin-bottom: 0pt;&quot;&gt;&lt;font color=#000080 size=2&gt;&lt;font color=#000080 size=2>; 

now want convert above output actual html content.

i.e

<p style=&quot;margin-bottom: 0pt;&quot;&gt;&lt;font color=#000080 size=2&gt;&lt;font color=#000080 size=2>; 

to

<p style="margin-bottom: 0pt;"><font color=#000080 size=2><font color=#000080 size=2> 

please suggest oracle function there or alternate.

thanks

you have use same function, time additional parameter 1.

select dbms_xmlgen.convert (           '<p style=&quot;margin-bottom: 0pt;&quot;&gt;&lt;font color=#000080 size=2&gt;&lt;font color=#000080 size=2>;',           1)   dual 

Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -