create table employee(name varchar2(100));
insert into employee(name)
values ('John');
create or replace function get_name(name_val varchar2) return varchar2
is
name_param varchar2;
begin
select name into name_param
from employee
where name = name_val;
return name_param;
end;