select * from tbl where id in (1,2) and contains(textV, 'something')>0;

SCOTT@orcl_11gR2> create table tbl
  2    (id     number primary key,
  3  	textb  blob)
  4  /

Table created.

SCOTT@orcl_11gR2> insert all
  2  into tbl values (1, utl_raw.cast_to_raw ('something'))
  3  into tbl values (2, utl_raw.cast_to_raw ('something'))
  4  select * from dual
  5  /

2 rows created.

SCOTT@orcl_11gR2> insert into tbl
  2  select distinct object_id,
  3  	    utl_raw.cast_to_raw ('something ' || object_name)
  4  from   user_objects
  5  where  object_id > 2
  6  /

740 rows created.

SCOTT@orcl_11gR2> create index tbl_idx on tbl (textb)
  2  indextype is ctxsys.context
  3  FILTER BY ID
  4  /

Index created.

SCOTT@orcl_11gR2> set autotrace on explain
SCOTT@orcl_11gR2> select id, utl_raw.cast_to_varchar2 (textb)
  2  from   tbl
  3  where  contains
  4  	      (textb,
  5  	       'something AND
  6  		(SDATA (ID = 1) OR
  7  		 SDATA (ID = 2))') > 0
  8  /

        ID
----------
UTL_RAW.CAST_TO_VARCHAR2(TEXTB)
------------------------------------------------------------------------------------------------------------------------
         1
something

         2
something


2 rows selected.


Execution Plan
----------------------------------------------------------
Plan hash value: 4198504031

---------------------------------------------------------------------------------------
| Id  | Operation                   | Name    | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |         |     1 |  2027 |     4   (0)| 00:00:01 |
|   1 |  TABLE ACCESS BY INDEX ROWID| TBL     |     1 |  2027 |     4   (0)| 00:00:01 |
|*  2 |   DOMAIN INDEX              | TBL_IDX |       |       |     4   (0)| 00:00:01 |
---------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("CTXSYS"."CONTAINS"("TEXTB",'something AND            (SDATA (ID
              = 1) OR             SDATA (ID = 2))')>0)

Note
-----
   - dynamic sampling used for this statement (level=2)

SCOTT@orcl_11gR2>