Oracle将多张表中查询出的列导出到xml中
select s.SERVICEOID,s.ORG_ID as ORGAN_ID,o.org_name as ORGAN_NAME,s.ITEMNAME as TITLE,
t.typetext as TYPENAME,s.WORKDAYS,s.APPFILEEXP as MATERIALLIST,WORKFLOW
from xzfw_service_base s,sys_organ o ,XZFW_SERVICE_TYPE t where s.ORG_ID = o.ORG_ID and s.typeid = t.typeid
将上面列查询出来的数据导出到xml中.