insert into report_data(report_id,report_parameters) values 
(8,
XMLTYPE('<?xml version="1.0" encoding="ISO-8859-1"?> 
 <Report>
  <Title>Incident Severity Report - 2009 Q1</Title> 
 <xaxis>
  <Id>INC_YEAR</Id> 
  <Name>Incidence Date - Year</Name> 
  </xaxis>
 <yaxis>
  <Id>COUNT(INCIDENT_ID)</Id> 
  <Name>Incidents</Name> 
  </yaxis>
  <Series>
  <Id>URGENCY_ID</Id> 
  <Name>URGENCY</Name>   
  </Series> 
   </Report>'));

select INC_YEAR,COUNT(INCIDENT_ID),
URGENCY_ID from VW_TAB;

select extract( report_parameters,'//xaxis/id').getstringval() 
from report_data where report_id =8;

select INC_YEAR,COUNT(INCIDENT_ID),
URGENCY_ID from VW_TAB;

SQL> with data as (
  2  select XMLTYPE('<?xml version="1.0" encoding="ISO-8859-1"?>
  3   <Report>
  4    <Title>Incident Severity Report - 2009 Q1</Title>
  5   <xaxis>
  6    <Id>INC_YEAR</Id>
  7    <Name>Incidence Date - Year</Name>
  8    </xaxis>
  9   <yaxis>
 10    <Id>COUNT(INCIDENT_ID)</Id>
 11    <Name>Incidents</Name>
 12    </yaxis>
 13    <Series>
 14    <Id>URGENCY_ID</Id>
 15    <Name>URGENCY</Name>
 16    </Series>
 17     </Report>') val from dual)
 18  select extractvalue(value(t),'/xaxis/Id') val
 19  from data, table(xmlsequence(extract(data.val,'/Report/xaxis'))) t
 20  /
VAL
---------------------------------------------------
INC_YEAR

select INC_YEAR,COUNT(INCIDENT_ID),
URGENCY_ID from VW_TAB;