You will have to create a Full-Text index on the column you want to search in. You have 2 types of index you can create for that : CTXCAT for small columns (5 lines max) or CONTEXT. The two have diffferent search options associated with them.
CTXCAT is more efficient especially if you have to search on another criteria than the FTS (on a date for example) since you can index other columns with standard B-Tree index WITHIN the CTXCAT structure, but this kind of index takes a lot of space, hence its limit for small columns.
CONTEXT indexes offer more possibilities in terms of search options on the FTS column, but performance suffers A LOT if you have to filter on other columns.
A drawback of CONTEXT is that up to 9iR2, it needs manual synchronisation (the index is not updated at each insert/update). From 10gR1, you can choose to update it at each DML operation. CTXCAT indexes are always automatically synchronised.
Now I'd suggest you read the documentation .
HTH & Regards,
ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .