游标分类汇总行转列oracleplsql

create or replace procedure dushigongyu IS
CURSOR myc IS SELECT t.sheng sheng,t.shi shi,t.qu qu
FROM linhusong.count_student t
GROUP BY (t.sheng,t.shi,t.qu)
ORDER BY  t.sheng ASC;
CURSOR myall IS SELECT * FROM linhusong.count_student;
myall_line myall%ROWTYPE;
myc_line myc%ROWTYPE;
boy NUMBER;
girl NUMBER;
age1 NUMBER;
age2 NUMBER;
BEGIN  
         FOR myc_line IN  myc LOOP
             boy :=0;
             girl :=0;
             age1 :=0;
             age2 :=0;
             FOR myall_line IN myall LOOP
             IF myall_line.sheng=myc_line.sheng AND
                myall_line.shi=myc_line.shi AND
                myall_line.qu=myc_line.qu
                 THEN
                 IF  myall_line.sex='boy'
                 THEN 
                  boy:=boy+1;
                  ELSE
                   girl:=girl+1;
                 END IF;
             END IF;