By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table data (code, description, value) as
select 'AAA', 'Item A', 42 from dual;
1 rows affected
create function get_data (data_row data%rowtype, fieldName varchar2)
return varchar2
as
begin
case upper(fieldName)
when 'CODE' then
return data_row.code;
when 'DESCRIPTION' then
return data_row.description;
when 'VALUE' then
return data_row.value;
else
return null;
end case;
end get_data;
/
declare
data_row data%rowtype;
begin
select * into data_row from data where code = 'AAA';
dbms_output.put_line('Value: ' || get_data(data_row, 'value'));
end;
/
1 rows affected
dbms_output:
Value: 42