"Noel" <tbal_at_go2.pl> wrote in message news:<bur796$g3h$1_at_inews.gazeta.pl>...
> Uzytkownik "Dil Jaey" <diljaey_at_comcast.net>
> > 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.
>
>
> SELECT 1
> FROM 30_column_table
> WHERE col1||col2||.....||col30 like '%find_this_stuff%'
>
> ... if length of that concatenate doesn't exeed 2000 or 4000 bytes...
> it could be done with one FTS, and long a few seconds with tousands of rows.
Thanks to everyone for your responses. I will be researching into
Intermedia/Oracle Text.
Received on Thu Jan 29 2004 - 11:05:03 CST
