var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem in indexing BLOB's
I have a table DOCUMENTS with a BLOB column which stores MS Word documents.
I want to search for some patterns in the document. Eg., Search for all the documents which have EMPLOYEE in it.
I used the following code to index the BLOB's.
CREATE INDEX my_cv_idx ON DOCUMENTS(BLOB_CONTENT) INDEXTYPE IS CTXSYS.CONTEXT;
I could successfully create index.
After creating index, I am trying to query the table:
select ein from documents where contains(blob_content,'oracle',1)>0;
This returns me 0 rows. I am sure that the document has oracle in it.
Can any please suggest me at the earliest, the mistake i have commited.
Thanks in Advance.