Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Search and Replace
use the replace function
example :
select replace('toto','o','a') from dual;
tata Received on Wed Jun 24 1998 - 17:19:26 CDT