有点复杂的sql语句

[qms_cs]

SELECT
xmlgroup(
SITE_NAME AS siteName,
SITE_NAME_CH AS siteNameCH,
SITE_URL AS siteUrl,
QUERY_VPN AS ws_queryVPNExpiration,
UPDATE_CLIENT_CONF AS ws_updateClientConfig,
COLLECT_UCD AS ws_collectUCDData,
QUERY_DOMAIN AS ws_canUseDomainPwd
OPTION ROW "site" ROOT "VPNSites")
INTO siteXml
FROM T_CLIENT_GATEWAY TCG WHERE TCG.SITE_NAME!='Other...';
一个存储过程里面的SQL语句，看不是很明白，求解释啊（DB2的存储过程，现在要转成oracle的）

[我心飞翔]

这好象是要将数据选择出来放到一个xml结构中。

[ssqtjffcu]

不会db2,帮不了你！！！

[yehaver]

玩DB2的一定是高手，

俺不会啊！爱莫能助。。。