Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Search Replace String function
Does oracle provides search replace string functionality?
e.g. lets say i have data into column as '(A + B + C) - (D + E)' I would like to have following : (
NVL(SUM(DECODE(b.lookup_code,'A',a.q_qty,0)),0) + NVL(SUM(DECODE(b.lookup_code,'B',a.q_qty,0)),0) + NVL(SUM(DECODE(b.lookup_code,'C',a.q_qty,0)),0)) -
In this case only thing needs to be done is search replace all values
with
NVL(SUM(DECODE(b.lookup_code,??,a.q_qty,0)),0)
Received on Wed Aug 09 2006 - 13:36:10 CDT