Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!nntpfeed-01.ops.asmr-01.energis-idc.net!newshub1.home.nl!home.nl!not-for-mail From: Frank Newsgroups: comp.databases.oracle.server Subject: Re: (can I) retrieve the terms from an InterMedia Text index Date: Fri, 10 Oct 2003 13:47:15 +0200 Organization: @Home Benelux Lines: 25 Message-ID: References: <1eb05eb9.0310071952.4c42ec5d@posting.google.com> NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news1.tilbu1.nb.home.nl 1065786009 31751 217.121.193.81 (10 Oct 2003 11:40:09 GMT) X-Complaints-To: abuse@home.nl NNTP-Posting-Date: Fri, 10 Oct 2003 11:40:09 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en In-Reply-To: <1eb05eb9.0310071952.4c42ec5d@posting.google.com> Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:244992 Relishguy wrote: > I am trying to get the individual words from a column in a table I > have indexed to make it searchable from InterMedia Text. This is the > set of words which would give at least one row in a search result set. > > Is this possible? I cannot find a select clause/syntax that will dump > out the index term values. > > TIA. > > Regards.. Check with the DBA: what languague option was installed? Assuming US English (The default) Check with the programmer: what stoplist was used when the index was created (Assuming the default, a.k.a none specified) Check the scripts: all words NOT in the stoplist should be indexed. Still leaves your question, which puzzles me - 'a set which would give at least one row in a search result set'? Any word not in the stoplist, I'd say. Are you using the contains syntax as required? -- Regards, Frank van Bortel