开发者

How do you display results data from a query

I am running the following SQL statement:

SELECT
开发者_Go百科    TS_MESSAGE,
    TX_SERVICENAME,
    TX_CONFIRMATION "Conf",
    TX_SS_MESSAGE,
    TX_OMS_MESSAGE,
    a.fl_resend_message
    from INTF_OMS.LOG_WEB_SERVICE_SS_INITIATED a
    where tx_servicename like '%mobileUserForcedToSignOff%' 
    --and tx_ss_message like '%e50702%'
    and tx_ss_message  like '%E30046%'
    and a.ts_message like '%25-JAN-11%'
    order by ts_message asc

I get the results I want, however the columns tx_ss_message contains the following information:

<?xml version="1.0" encoding="UTF-8"?>
<MobileUserForcedToSignOff>
  <MessageId></MessageId>
  <MessageDate>20110125</MessageDate>
  <MessageTime>1853</MessageTime>
  <DispatchUserId>E30046</DispatchUserId>
  <MobileUserId>e19952</MobileUserId>
</MobileUserForcedToSignOff>

What I really want, is when I run the query, is for it to return ONLY The DispatchUserID, MessageDate, and MobileUserID.

Any suggestions on how to accomplish this?


Write a query outside the one you already have that parses the xml for the 3 items you want

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜