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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Including/parsing out text from within document in query..

Re: Including/parsing out text from within document in query..

From: <noel.whelan_at_gmail.com>
Date: 19 Jan 2006 17:32:28 -0800
Message-ID: <1137720747.987064.211420@g47g2000cwa.googlegroups.com>


Issue was worked out on OTN forum. I can query the internal index table to identify content within the document(s) of interest, for instance:

SELECT i.id, idx_i.token_text AS email
FROM items i, dr$items_idx$i idx_i
WHERE CONTAINS(i.item, '%content%') > 0

	AND idx_i.token_text LIKE '%@%.%'
	AND CONTAINS(i.item, idx_i.token_text) > 0
ORDER BY email;

http://forums.oracle.com/forums/thread.jspa?forumID=71&threadID=354281 Received on Thu Jan 19 2006 - 19:32:28 CST

Original text of this message

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