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: newbie: examples of regular expressions in oracle?

Re: newbie: examples of regular expressions in oracle?

From: Aleksander Dragnes <ADragnes_at_gmail.com>
Date: 11 Mar 2005 08:59:03 -0800
Message-ID: <1110560343.791217.7770@l41g2000cwc.googlegroups.com>


Why not user REPLACE ( char , search_string [, replacement_string] )?

clob_column = REPLACE(clob_column, '<tag to replace>')

Both char and search_string can be CLOBs. Of course this would only work if you do not have varying case and varying attributes.

-- 
Aleksander
Received on Fri Mar 11 2005 - 10:59:03 CST

Original text of this message

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