SQL & PL/SQL

Hi,

I have a table with columns tablexxx (first name, last name, location, department, description etc) also description can be long text(CLOB TYPE) now my report query i want to enter a combination of these values in any order to search and return correct rows like below,

2 sample rows below:

FIRST NAME, LAST NAME, LOCATOION,   DEPT,        DESCRIPTION

==========================================================

Mercy     Baker,     Newark,     HR,    "Was hired in January 2010 as asst. Manager"

select  xxxxx from tablexxx

WHERE CONTAINS (first||last||locations||depatment||description, :search_text)   > 0;

  also tried INSTR()

the problem is somebody can enter values in different order like ==>   'Dallas Graig Sales January 2010 '  or ' January 2010 Graig Dallas Sales'

so what is the best approach to search the rows here? also can somebody give a hint on text search usage

in Oracle 11g2

thanks all.