Simple Document Search with Oracle Text Database

Recently, I need to implement a document search in oracle database.  Since I have many different document formats like PDF, Excel, Words .... , I have decided to try this with Oracle Text functionality.

Concluded several steps to do

1. create table for storing document files

  CREATE TABLE "DOCS"
   (  "FILEBLOB" BLOB );


2. create full text search index

  CREATE INDEX "IDX_FILEBLOB" ON "DOCS" ("FILEBLOB")
   INDEXTYPE IS "CTXSYS"."CONTEXT"  PARAMETERS ('sync (on commit)');


3. adding something to table DOCS

4. try the search

select * from DOCS where contains(fileblob, 'text you want to search',1)>0;