REGEXP Functions in 10g (10.2.0.2.0)

Is there any way to do remove a few lines from a paragraph using regexp functions?

Something like : sed -e '/temp/,/test/d' text.txt ?

This is what I need:

select 'text' title from dual union select 'test' from dual union select 'temp' from dual union select 'doc' from dual;

TITLE

Required Output after running regexp functions:

TITLE

ie., remove anything between 'temp' and 'test' (inclusive) ...

Thanks

-Ad Received on Thu Aug 06 2009 - 15:40:31 CDT