Date: Thu, 19 Sep 2002 10:10:22 -0400
Reply-To: Vaishali Joshi <vjoshi73@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Vaishali Joshi <vjoshi73@YAHOO.COM>
Subject: doing a kew word search
I have an oracle table called history_text with a LONG datatype column
called History_doc. There is another column called IDNUM (Primary Key).
I have a list of 40 keywords. Basically I want to pull out idnums whose
history_doc contain any of these 40 keywords. I also need to keep a track
of all the words found. I am trying to come up with the most efficient way
of solving this problem. Right now I have set up a text file with 40
select statements for each keyword and that seems highly inefficient.
Has anyone does analysis similar to this?
Any suggestions will be appreciated.