Hi ,
i have a table having column of data type blob
and its one row having one document having length as
select length(file_contents) from table_name where columnid=1;
--------------------
5914612
this is not working for this much length having 124 pages as word document
select file_contents from table_name where
CONTAINS(File_contents, 'SEARCH_STRING ') > 0
https://docs.oracle.com/database/121/CCAPP/GUID-5BE34ED3-4B35-412A-BD53-E3F663B9EB8C.htm
is their any way for searching for this much length document length.
Any ideas will be helpful.