Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Including/parsing out text from within document in query..
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) > 0ORDER BY email;
http://forums.oracle.com/forums/thread.jspa?forumID=71&threadID=354281 Received on Thu Jan 19 2006 - 19:32:28 CST