User699558600 posted
write a clean string function as shown below
SQL> create or replace function clean_str(in_string in varchar2)
2 return varchar2
3 is
4 out_string varchar2(4000);
5 remove_char varchar2(100);
6 begin
7 remove_char:='E:\Elink\spancopowerdocs\';
8 select
9 REPLACE(TRANSLATE(in_string,remove_char , ' '),' ',NULL)
10 into out_string
11 FROM dual;
12 return (out_string);
13 end;
14 /
Now
Once function is created write a query like this to check whether you get correct data
select clean_str(a) from yourTableName;
once you are saisfied do this
Update yourTableName Set columnName = clean_str(a);
