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

I would like to know if there is a way to include text from inside a document in the data yielded by an Oracle Text CONTAINS query. I've got a table with the fields: id, item (in which 'item' is a blob including word docs and pdf files), in which case I could execute this query:

	select id from items
	where contains(item, '%content%', 1) > 0;

I want to then, in this case, collect the e-mail address(es) in each document yielded by the query to provide back to the client. I'd imagine I could write an expression to filter these out, illustrated not very well perhaps in this [pseudo]query:

	select id, (item ~ '^.+@.+\\..+$') into email from items
	where contains(item, '%content%', 1) > 0;

In this case, 'email' would include each instance of text within the doc which conformed to the expression in the query. I'm not certain if this is even close to what I'd need to do; but is there a way to do this?

Currently installed: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

Thank you. Received on Fri Jan 13 2006 - 18:38:28 CST