Pretty print XML data within Oracle Databases

Just a short post without further explanation.

Pretty printing xml in Oracle 10g and 11g differences quite a bit:

10g:

SELECT XMLTYPE('<html><body><p>Hallo, Welt.</p></body></html>').extract('/') FROM dual;

11g:

SELECT XMLSERIALIZE(Document XMLTYPE('<html><body><p>Hallo, Welt.</p></body></html>') AS CLOB INDENT SIZE = 2) FROM dual;

2 comments

Post a comment | Trackback URI | RSS 2.0 feed for those comments

Iris wrote:

Test your code using this site:

https://jsonformatter.org/xml-pretty-print

Posted on March 9, 2018 at 2:22 PM | Permalink
Renuka wrote:

May I get the full code of the demo page

Posted on June 13, 2022 at 8:53 PM | Permalink

Post a Comment

Name *

Email *

Website

Sum of four + ten ? *

Comment

Your email is never published. We need your name and email address only for verifying a legitimate comment. For more information, a copy of your saved data or a request to delete any data under this address, please send a short notice to michael@simons.ac from the address you used to comment on this entry.
By entering and submitting a comment, wether with or without name or email address, you'll agree that all data you have entered including your IP address will be checked and stored for a limited time by Automattic Inc., 60 29th Street #343, San Francisco, CA 94110-4929, USA. only for the purpose of avoiding spam. You can deny further storage of your data by sending an email to support@wordpress.com, with subject “Deletion of Data stored by Akismet”.
Required fields are marked *

info.michael-simons.eu