Pretty print XML data within Oracle Databases

June 5, 2013 by Michael

Just a short post without further explanation.

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


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


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


  1. Iris wrote:

    Test your code using this site:

    Posted on March 9, 2018 at 2:22 PM | Permalink
  2. 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

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 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, with subject “Deletion of Data stored by Akismet”.
Required fields are marked *