SQL & PL/SQL

Greetings,

Using Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

Sample data:

create table test_base_table (
     MY_ID        number,
     FY           number,
     FIRST_VALUE  number,
     SECOND_VALUE number);

insert into test_base_table values (100, 2012, 10, 100);
insert into test_base_table values (100, 2013, 20, 200);
insert into test_base_table values (100, 2014, 30, 300);
insert into test_base_table values (101, 2012, 15, 150);
insert into test_base_table values (101, 2013, 25, 250);
insert into test_base_table values (101, 2014, 35, 350);

select *
from test_base_table
pivot(sum(FIRST_VALUE) M_YEAR_, sum(SECOND_VALUE) R_YEAR_
  for fy in (2012, 2013, 2014)) 

Result:

MY_ID	2012_M_YEAR_	2012_R_YEAR_	2013_M_YEAR_	2013_R_YEAR_	2014_M_YEAR_	2014_R_YEAR_
101	15	150	25	250	35	350
100	10	100	20	200	30	300

How can I rename the fields as M_YEAR_2012, M_YEAR_2013 ?

Thanks, ~Johnny