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 ;
Do you get answer to this query. I am also facing the same issue. Please suggest if you have solution for this.