Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Search for a word in all columns in all rows

Search for a word in all columns in all rows

From: Dil Jaey <diljaey_at_comcast.net>
Date: 22 Jan 2004 07:46:53 -0800
Message-ID: <d8e274e1.0401220746.268c002b@posting.google.com>


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 Received on Thu Jan 22 2004 - 09:46:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US