Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table match_results (
  match_date       date,
  location         varchar2(20),
  home_team_name   varchar2(20),
  away_team_name   varchar2(20),
  home_team_points integer,
  away_team_points integer
);
insert into match_results values ( date'2018-01-01', 'Snowley', 'Underrated United', 'Terrible Town', 2, 0 );
1 rows affected

declare 

plsql_block VARCHAR2(500);
lv_col_value VARCHAR2(500);

begin 


dbms_output.put_line('ColumnName|Value');

for v1 in (select column_name 
            from user_tab_columns where table_name ='MATCH_RESULTS'
           order by column_id)
 loop
    
    --Add filter as desired but restrict result set to one row
    plsql_block := 'select ' || v1.column_name  || ' from MATCH_RESULTS Where LOCATION = ''Snowley'' and rownum < 2';
    execute immediate plsql_block into lv_col_value;
    dbms_output.put_line(v1.column_name||'| '||lv_col_value);

 end loop;

end;
/
1 rows affected

dbms_output:
ColumnName|Value
MATCH_DATE| 01-JAN-18
LOCATION| Snowley
HOME_TEAM_NAME| Underrated United
AWAY_TEAM_NAME| Terrible Town
HOME_TEAM_POINTS| 2
AWAY_TEAM_POINTS| 0