我现在写了一个这样的语句,但是只能得到一个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
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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货