Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table emp(id number, name varchar2(1000), age number)
insert into emp values (1, 'emp1',25)
1 rows affected

insert into emp values (2, 'emp1',30)
1 rows affected

insert into emp values (2, 'emp1',28)
1 rows affected

insert into emp values (3, 'emp1',40)
1 rows affected

select * from emp


ID
NAME
AGE


1
emp1
25

2
emp1
30

2
emp1
28

3
emp1
40


CREATE OR REPLACE FUNCTION UPDATE_MY_TABLE(Y IN number, Z IN number)
RETURN NUMBER IS
BEGIN
EXECUTE IMMEDIATE 'UPDATE emp SET age = ' || Y || ' WHERE id = ' || Z;
RETURN SQL%ROWCOUNT;
END;
/
declare
rows_affected number;
begin
rows_affected := UPDATE_MY_TABLE(50,2);
dbms_output.put_line(rows_affected);
end;
/
1 rows affected

dbms_output:
2

select * from emp


ID
NAME
AGE


1
emp1
25

2
emp1
50

2
emp1
50

3
emp1
40