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!

Special charecter issue in XMLELEMENT

sadasivamJul 22 2019 — edited Jul 23 2019

Hi,

When I am generating xml data from my table data,my text having special characters are converted to different format(> to >) .My requirement is just to convert row to xml format and store it into CLOB field in another table.

Is it possible to store it as similar to my text field format?

select xmlelement("tab1",'test->test') from dual

XML

------------------------------

Thanks.

This post has been answered by BluShadow on Jul 22 2019

Jump to Answer

Added on Jul 22 2019

7 comments

2,723 views