SQL & PL/SQL

Trying to have multiple groups in xml, not sure how to get it to work.

create table "TEST" (
partner varchar2(100),
phase varchar2(100),
country varchar2(100),
state varchar2(2),
county varchar2(100),
number1 varchar2(100),
number2 varchar2(100),
number3 varchar2(100)

);


insert into test values ('partner1','phase1','USA','ME','county3','111','222','333');
insert into test values ('partner1','phase2','USA','NY','county1','111','222','333');
insert into test values ('partner1','phase1','Russia','NY','county2','111','222','333');
insert into test values ('partner1','phase1','USA','FL','county1','111','222','333');
insert into test values ('partner2','phase2','USA','MD','county1','111','222','333');
insert into test values ('partner2','phase1','China','NY','county1','111','222','333');
insert into test values ('partner2','phase2','USA','NY','county1','111','222','333');
insert into test values ('partner2','phase1','Russia','FL','county1','111','222','333');
insert into test values ('partner3','phase1','USA','NY','county1','111','222','333');
insert into test values ('partner3','phase2','USA','NY','county1','111','222','333');
insert into test values ('partner3','phase1','USA','CA','county1','111','222','333');



Want xml to look something like :


<XML>
  <PARTNER=1> 
      <PHASE 1>
            <COUNTRY>
                    <STATE>
                              <COUNTY>
                                          <NUMBER1 =1111>
                                          <NUMBER2 =2222>
                                          <NUMBER3 =3333>
                              </COUNTY>
                    </STATE>
            <COUNTRY>
                              
      
      </PHASE 1>
      <PHASE 2>
      
      
      </PHASE 2>
      <PHASE 3>
      
      </PHASE 3>
      

  </PARTNER>
  .
  .
  .
  
  <PARTNER =2> 
  
  </PARTNER>
  
  <PARTNER =3> 
  
  </PARTNER>
    
</XML>

so first grouped by partner, then grouped inside partner by phase, then after that by country, etc..
any help is appreciated. thank you