How to query a CLOB column in Oracle March 28, 2023 by Tarik This works select DBMS_LOB.substr(myColumn, 3000) from myTable