SELECT*FROMXMLTABLE('$B/DEAL_BASIC/USER_DEAL_INFO'PASSING
XMLTYPE('<?xmlversion="1.0"encoding="gb2312"?>
<DEAL_BASIC>
<USER_DEAL_INFO>
<USER_DEAL_ID>1000100001</USER_DEAL_ID>
<DEAL_INURE_TIME>20081130</DEAL_INURE_TIME>
<DEAL_EXPIRE_TIME>30000101</DEAL_EXPIRE_TIME>
<DEAL_CREATE_TIME>20081130</DEAL_CREATE_TIME>
</USER_DEAL_INFO>
<USER_DEAL_INFO>
<USER_DEAL_ID>1000100002</USER_DEAL_ID>
<DEAL_INURE_TIME>20081131</DEAL_INURE_TIME>
<DEAL_EXPIRE_TIME>30000102</DEAL_EXPIRE_TIME>
<DEAL_CREATE_TIME>20081131</DEAL_CREATE_TIME>
</USER_DEAL_INFO>
</DEAL_BASIC>')ASB
COLUMNSUSER_DEAL_IDVARCHAR2(50)PATH
'/USER_DEAL_INFO/USER_DEAL_ID',
DEAL_INURE_TIMEVARCHAR2(50)PATH
'/USER_DEAL_INFO/DEAL_INURE_TIME',
DEAL_EXPIRE_TIMEVARCHAR2(50)PATH
'/USER_DEAL_INFO/DEAL_EXPIRE_TIME',
DEAL_CREATE_TIMEVARCHAR2(50)PATH
'/USER_DEAL_INFO/DEAL_CREATE_TIME')

优质内容筛选与推荐>>
1、【BZOJ1101】【洛谷P3455 】【POI2007】ZAP-Queries（莫比乌斯反演）
2、78.游戏项目-加载窗口-加载图片
3、第01组 Beta冲刺（2/4）
4、tar 压缩去除目录
5、leetcode-Gas Station-134