Display Oracle SQL Developer XMLTYPE

Do you see annoying (XMLTYPE) in Oracle SQL Developer output?
Wrap the column in the xmlType.getClobVal function to see the actual data.

  WITH q AS ( SELECT XMLTYPE ( '' ) AS col1 FROM DUAL )
SELECT q.col1
     , XMLTYPE.GETCLOBVAL ( q.col1 )
  FROM q ;

xml_annoying

Posted in XML
One comment on “Display Oracle SQL Developer XMLTYPE
  1. MOHAMMAD RAFI ANSARI says:

    Do you get answer to this query. I am also facing the same issue. Please suggest if you have solution for this.

Leave a Reply

Your email address will not be published. Required fields are marked *

*