pivot xml

 How do you query the output from the 'pivot xml' sql?
Just as an example, How can you query the output(xmltype) from this sql so that it is flattened into a relational type view?
select *
  from ( select owner, count(*) as owner_segment_count
          from  dba_segments
         where  owner in( 'OLAPSYS','ORDSYS','QDATA','SYS','SYSMAN','SYSTEM','XDB' )
         group by owner )
  pivot xml( sum( owner_segment_count ) as owner_segment_count for owner in( any ) )