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

October 10, 2016

  • 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 *