I have tried adding the below comments in the resources tab it's not working
substr(colum,1,1000)can someone help me here thanks in advance<span>select</span> DBMS_LOB.substr(myColumn, <span>3000</span>) <span>from</span> myTable
Hi @John Christopher welcome to the community. Are you trying to setup a scriptrunner resource? Have you reviewed this page?
It's all set up . I can able to query but my question is how to view the clob data.
when I try to view the CLOB column I get like this - oracle.sql.CLOB@814328b
It looks like you're new here. Sign in or register to get started.