Hi Experts,
I hope you and your family are doing well.
I had a request to format the data like a pivot clause, each strata(yrs, mth, group_id, type) has a unique name and I like to list the names_total as columns.
here is the example:
CREATE TABLE T1
(YRS NUMBER,
MTH NUMBER,
TYPE NUMBER,
GROUP_ID NUMBER,
name VARCHAR2(26 BYTE),
TOT NUMBER);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,0,1,'James',1);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,0,1,'scott',371);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,0,1,'yelen',13);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,1,1,'James',6);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,1,1,'scott',522);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,1,1,'yelen',32);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,1,2,'scott',0.5);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,1,2,'yelen',0);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,2,1,'scott',123);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,2,1,'yelen',10);
Insert into T1 (YRS,MTH,GROUP_ID,TYPE,name,TOT) values (2020,1,2,1,'baker',0.2);
select * from T1
and like to format the data like this:
Thanks in advance,
Nick