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="margin-bottom: 0pt;"><font color=#000080 size=2><font color=#000080 size=2>;
now want convert above output actual html content.
i.e
<p style="margin-bottom: 0pt;"><font color=#000080 size=2><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="margin-bottom: 0pt;"><font color=#000080 size=2><font color=#000080 size=2>;', 1) dual
Comments
Post a Comment