Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE africancrisisdata (country_abv, year, banking_crisis) AS
SELECT 'ABC', 2022, 'XYZ' FROM DUAL;
1 rows affected

create or replace type african_crisis_row as object(
country_abv    varchar2(4),
year           number(5),
banking_crisis varchar2(10)
);
create or replace type t_african_crisis_table as table of african_crisis_row;
create or replace function african_crisis (   
  country_abv in varchar2,
  year_min    in number,
  year_max    in number
) return t_african_crisis_table
as
  v_ret t_african_crisis_table;
begin
  select african_crisis_row(country_abv, year, banking_crisis)
  bulk collect into v_ret
  from  africancrisisdata
  where country_abv = country_abv
  and   year between year_min and year_max;

  return v_ret;
end african_crisis;
/
SELECT * FROM USER_ERRORS;
SELECT *
FROM   TABLE(african_crisis('ABC', 2000, 3000));


COUNTRY_ABV
YEAR
BANKING_CRISIS


ABC
2022
XYZ