SCOTT@orcl_11gR2> CREATE TABLE producttitle (title  VARCHAR2(30))
  2  /

Table created.

SCOTT@orcl_11gR2> INSERT ALL
  2  INTO producttitle (title) VALUES ('GIRL WHO')
  3  INTO producttitle (title) VALUES ('THAT GIRL WHO')
  4  INTO producttitle (title) VALUES ('AGIRL WHOM')
  5  INTO producttitle (title) VALUES ('THE GIRL WHO DID IT')
  6  INTO producttitle (title) VALUES ('ONE GIRL WHO DID NOT')
  7  INTO producttitle (title) VALUES ('OTHER DATA')
  8  SELECT * FROM DUAL
  9  /

6 rows created.

SCOTT@orcl_11gR2> SELECT * FROM producttitle pt
  2  WHERE  pt.title LIKE '%GIRL WHO%'
  3  /

TITLE
------------------------------
GIRL WHO
THAT GIRL WHO
AGIRL WHOM
THE GIRL WHO DID IT
ONE GIRL WHO DID NOT

5 rows selected.

SCOTT@orcl_11gR2> CREATE INDEX title_idx
  2  ON producttitle (title)
  3  INDEXTYPE IS CTXSYS.CONTEXT
  4  PARAMETERS ('STOPLIST CTXSYS.EMPTY_STOPLIST')
  5  /

Index created.

SCOTT@orcl_11gR2> SELECT * FROM producttitle pt
  2  WHERE  CONTAINS (pt.title, 'GIRL WHO') > 0
  3  /

TITLE
------------------------------
GIRL WHO
THAT GIRL WHO
THE GIRL WHO DID IT
ONE GIRL WHO DID NOT

4 rows selected.

SCOTT@orcl_11gR2> SELECT * FROM producttitle pt
  2  WHERE  CONTAINS (pt.title, '%GIRL WHO%') > 0
  3  /

TITLE
------------------------------
GIRL WHO
THAT GIRL WHO
AGIRL WHOM
THE GIRL WHO DID IT
ONE GIRL WHO DID NOT

5 rows selected.