Oracle Database Discussions

Hello All Group Members/Experts
I want to build a google type search engine on a multi table database. where a user can search an employee by typing any text. Result set should be the list of all those employees whose records may have the text in any field of any table.

I was planning on combining all fields in each record in a string delaminated by a space or any other charcter , then break the search criteria down into individual words and have a LIKE clause for each.
for example

select EMP_ID, NAME || ' ' || ADDRESS || ' ' || PHONE_NO as TEXT from employee

select EMP_ID, PROPERTY || PROPERTY_ADDRESS TEXT from emp_property

This seems like allot of processing though, concerned about efficiency.

Any one can help? to provide a better technique.... Please