select dbms_lob.substr(clob_column, 2000, 1) from my_table; select dbms_lob.substr(clob_column, dbms_lob.getlength(clob_column), 1) from my_table;