Several times we want to Display CLOB data in Toad with no success. Here is an interesting SQL example which can be used to display the data.

Example: SELECT CAST(SUBSTR(DESCRLONG,1,40) AS VARCHAR2(40)) AS DESCRLONG FROM PS_MAINTENANCE_LOG ORDER BY DTTM_IMPORTED DESC

Advertisements