-- The max value for SUBSTR is 2000 in SQL Developer -- (max capacity is 32767) SELECT t.*, DBMS_LOB.getlength(t.file_content) blob_length_bytes, DBMS_LOB.getchunksize(t.file_content) chunk_size, DBMS_LOB.instr(t.file_content,UTL_RAW.CAST_TO_RAW('