SCOTT@orcl_11gR2> create table msg
  2    (text  varchar2(60))
  3  /

Table created.

SCOTT@orcl_11gR2> insert all
  2  into msg values ('this is the test;')
  3  into msg values ('test successfull;')
  4  into msg values ('test completed')
  5  into msg values ('test pending')
  6  into msg values ('pending')
  7  into msg values ('hello')
  8  into msg values ('hi')
  9  into msg values ('no pending')
 10  into msg values ('test pending')
 11  select * from dual
 12  /

9 rows created.

SCOTT@orcl_11gR2> create index msg_text_idx on msg (text)
  2  indextype is ctxsys.context
  3  /

Index created.

SCOTT@orcl_11gR2> variable search_string varchar2(60)
SCOTT@orcl_11gR2> exec :search_string := 'test pending'

PL/SQL procedure successfully completed.

SCOTT@orcl_11gR2> select * from msg
  2  where  contains
  3  	      (text,
  4  		 replace (:search_string, ' ', ' or ')) > 0
  5  /

TEXT
------------------------------------------------------------
this is the test;
test successfull;
test completed
test pending
pending
no pending
test pending

7 rows selected.

SCOTT@orcl_11gR2>