Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie: examples of regular expressions in oracle?
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.
-- AleksanderReceived on Fri Mar 11 2005 - 10:59:03 CST
![]() |
![]() |