Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table dynamicorders 
(
    order_date date,
    order_total number(8),
    name varchar2(100)
);
BEGIN
insert into dynamicorders values( DATE '2021-01-05', 705, 'jhone'); 
insert into dynamicorders values( DATE '2021-01-15', 715, 'steve'); 
insert into dynamicorders values( DATE '2021-01-17', 50, 'jhone'); 
insert into dynamicorders values( DATE '2021-02-09', 802, 'mular'); 
insert into dynamicorders values( DATE '2021-03-12', 812, 'steve'); 
insert into dynamicorders values( DATE '2021-03-29', 829, 'steve'); 
insert into dynamicorders values( DATE '2021-04-03', 903, 'jhone'); 
insert into dynamicorders values( DATE '2021-04-29', 150, 'steve'); 
insert into dynamicorders values( DATE '2021-05-19', 100, 'steve'); 
insert into dynamicorders values( DATE '2022-01-10', 300, 'steve');
insert into dynamicorders values( DATE '2022-01-18', 400, 'mular');
END;
/
1 rows affected

SELECT name,
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-01-01' THEN order_total END) AS "21-Jan",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-02-01' THEN order_total END) AS "21-Feb",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-03-01' THEN order_total END) AS "21-Mar",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-04-01' THEN order_total END) AS "21-Apr",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-05-01' THEN order_total END) AS "21-May",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-06-01' THEN order_total END) AS "21-Jun",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-07-01' THEN order_total END) AS "21-Jul",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-08-01' THEN order_total END) AS "21-Aug",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-09-01' THEN order_total END) AS "21-Sep",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-10-01' THEN order_total END) AS "21-Oct",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-11-01' THEN order_total END) AS "21-Nov",
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2021-12-01' THEN order_total END) AS "21-Dec",
       SUM(CASE TRUNC(order_date, 'YY') WHEN DATE '2021-01-01' THEN order_total END) AS TOTAL,
       SUM(CASE TRUNC(order_date, 'MM') WHEN DATE '2022-01-01' THEN order_total END) AS "22-Jan"
FROM   dynamicorders d
GROUP BY name


NAME
21-Jan
21-Feb
21-Mar
21-Apr
21-May
21-Jun
21-Jul
21-Aug
21-Sep
21-Oct
21-Nov
21-Dec
TOTAL
22-Jan


jhone
755
null
null
903
null
null
null
null
null
null
null
null
1658
null

steve
715
null
1641
150
100
null
null
null
null
null
null
null
2606
300

mular
null
802
null
null
null
null
null
null
null
null
null
null
802
400

NAME	21-Jan	21-Feb	21-Mar	21-Apr	21-May	21-Jun	21-Jul	21-Aug	21-Sep	21-Oct	21-Nov	21-Dec	TOTAL	22-Jan
jhone	755	null	null	903	null	null	null	null	null	null	null	null	1658	null
steve	715	null	1641	150	100	null	null	null	null	null	null	null	2606	300
mular	null	802	null	null	null	null	null	null	null	null	null	null	802	400