Multiple REPLACE function in Oracle
Posted
by Adnan
on Stack Overflow
See other posts from Stack Overflow
or by Adnan
Published on 2010-06-01T06:18:24Z
Indexed on
2010/06/01
6:23 UTC
Read the original article
Hit count: 207
I am using the REPLACE function in oracle to replace values in my string like;
SELECT REPLACE('THE NEW VALUE IS #VAL1#','#VAL1#','55') from dual
So this is OK to replace one value, but what about 20+, should I use 20+ REPLACE function or is there a more practical solution.
All ideas are welcome.
© Stack Overflow or respective owner
