REGEXP Functions in 10g (10.2.0.2.0)

Giganews Newsgroups
Subject: REGEXP Functions in 10g (10.2.0.2.0)
Posted by:  admin (adm…@rbtron.com)
Date: Thu, 6 Aug 2009

Hi,

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
--------------------------
doc
temp
test
text

Required Output after running regexp functions:

TITLE
--------------------------
doc
text

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

Thanks

-Ad

Replies