SELECT * FROM XMLTABLE('$B/DEAL_BASIC/USER_DEAL_INFO'PASSING
XMLTYPE('<?xml version="1.0" encoding="gb2312" ?>
1000100001
20081130
30000101
20081130
1000100002
20081131
30000102
20081131
') ASB
COLUMNS USER_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')