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