Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
   id    INTEGER  NOT NULL 
  ,name  VARCHAR(1) NOT NULL
  ,value VARCHAR(10) NOT NULL
);

begin
INSERT INTO mytable(id,name,value) VALUES (1,'a','hel');
INSERT INTO mytable(id,name,value) VALUES (2,'b','dev2');
INSERT INTO mytable(id,name,value) VALUES (3,'c','new3');
INSERT INTO mytable(id,name,value) VALUES (4,'d','can6');
INSERT INTO mytable(id,name,value) VALUES (5,'e','kun8');
INSERT INTO mytable(id,name,value) VALUES (6,'f','luv4');
end;
/
1 rows affected

select 
    id, 
    name, 
    case when regexp_like(value, '\d+$')
        then regexp_replace(value, '^(\w+)(\d+)$', '\1' || 'qwe' || '\2')
        else value
    end value
from mytable


ID
NAME
VALUE


1
a
hel

2
b
devqwe2

3
c
newqwe3

4
d
canqwe6

5
e
kunqwe8

6
f
luvqwe4


update mytable
set value = regexp_replace(value, '^(\w+)(\d+)$', '\1' || 'qwe' || '\2')
where regexp_like(value, '\d+$')
5 rows affected

select * from mytable


ID
NAME
VALUE


1
a
hel

2
b
devqwe2

3
c
newqwe3

4
d
canqwe6

5
e
kunqwe8

6
f
luvqwe4