我现在写了一个这样的语句,但是只能得到一个Item标志中的值,我是要得到Item标志中的每一项的一个列表ArrayList,不知道这个SQL如何写?
select seqnum,companyname,bookname,  
  b.xmldata.extract('/Root/DataSheets/RptShareOfHolders/ImburseFromGovernment /Item/nameofproject/text()').getStringVal()  nameofproject,
  b.xmldata.extract('/Root/DataSheets/RptShareOfHolders/ImburseFromGovernment /Item/department/text()').getStringVal()  department,
  b.xmldata.extract('/Root/DataSheets/RptShareOfHolders/ImburseFromGovernment /Item/date/text()').getStringVal()  date1,
  b.xmldata.extract('/Root/DataSheets/RptShareOfHolders/ImburseFromGovernment /Item/capacity/text()').getStringVal()  capacity,
  b.xmldata.extract('/Root/DataSheets/RptShareOfHolders/ImburseFromGovernment /Item/accept/text()').getStringVal()  accept1,
  b.xmldata.extract('/Root/DataSheets/RptShareOfHolders/ImburseFromGovernment /Item/type/text()').getStringVal()  type1,
  b.xmldata.extract('/Root/DataSheets/RptShareOfHolders/ImburseFromGovernment /Item/refund/text()').getStringVal()  refund
 
from t_business_data  a,T_XMLDATA b  
            WHERE a.bid = b.bid and a.bid=2884