Re: Search for a word in all columns in all rows

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Thu, 22 Jan 2004 11:21:46 -0600
Message-ID: <ge10101dgmr4bvjkc2rtufnhj51u2kacon@4ax.com>

diljaey_at_comcast.net (Dil Jaey) wrote:

>I am allowing users to enter in a keyword search via a web interface
>and in the backend Oracle 9i is requested to search for that keyword
>in all columns (30) for every row (thousands) that exists within a
>given table(s).
>
>Is this a relatively simple task to perform or is this a path that
>should not be traveled.
>
>Thanks,
>DJ

( Cross-posting is discouraged)

Look into Oracle's InterMedia ( formerly Context) - it is designed to do those kind of searches Received on Thu Jan 22 2004 - 11:21:46 CST