SELECT str FROM table WHERE CONTAINS(?, str, 1) > 0

CREATE TABLE tab (str VARCHAR(255))
INSERT INTO tab VALUES ('old shoes')
INSERT INTO tab VALUES ('make money')
INSERT INTO tab VALUES ('sold')
INSERT INTO tab VALUES ('unrelated')

SCOTT@orcl_11g> CREATE TABLE tab (str VARCHAR(255))
  2  /

Table created.

SCOTT@orcl_11g> BEGIN
  2    INSERT INTO tab VALUES ('old shoes');
  3    INSERT INTO tab VALUES ('make money');
  4    INSERT INTO tab VALUES ('sold');
  5    INSERT INTO tab VALUES ('unrelated');
  6  END;
  7  /

PL/SQL procedure successfully completed.

SCOTT@orcl_11g> INSERT INTO tab SELECT object_name FROM user_objects
  2  /

773 rows created.

SCOTT@orcl_11g> CREATE INDEX idx ON tab (str) INDEXTYPE IS CTXSYS.CTXRULE
  2  /

Index created.

SCOTT@orcl_11g> EXEC DBMS_STATS.GATHER_TABLE_STATS (USER, 'TAB')

PL/SQL procedure successfully completed.

SCOTT@orcl_11g> SET AUTOTRACE ON
SCOTT@orcl_11g> SELECT * FROM tab
  2  WHERE  MATCHES (str, 'I sold shoes to make money') > 0
  3  /

STR
------------------------------------------------------------------------------------------------------------------------
make money
sold


Execution Plan
----------------------------------------------------------
Plan hash value: 1948011179

------------------------------------------------------------------------------------
| Id  | Operation                   | Name | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |      |    39 |   780 |     2   (0)| 00:00:01 |
|   1 |  TABLE ACCESS BY INDEX ROWID| TAB  |    39 |   780 |     2   (0)| 00:00:01 |
|*  2 |   DOMAIN INDEX              | IDX  |       |       |     0   (0)| 00:00:01 |
------------------------------------------------------------------------------------

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

   2 - access("CTXSYS"."MATCHES"("STR",'I sold shoes to make money')>0)


Statistics
----------------------------------------------------------
        238  recursive calls
          0  db block gets
        313  consistent gets
          0  physical reads
          0  redo size
        469  bytes sent via SQL*Net to client
        416  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          2  sorts (memory)
          0  sorts (disk)
          2  rows processed

SCOTT@orcl_11g> SET AUTOTRACE OFF