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 ;
Read More Display Oracle SQL Developer XMLTYPE