title: How do you display results data from a query
body: <p>I am running the following SQL statement:</p>
  
  <pre><code>SELECT
      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
  </code></pre>
  
  <p>I get the results I want, however the columns tx_ss_message contains the following information:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;MobileUserForcedToSignOff&gt;
    &lt;MessageId&gt;&lt;/MessageId&gt;
    &lt;MessageDate&gt;20110125&lt;/MessageDate&gt;
    &lt;MessageTime&gt;1853&lt;/MessageTime&gt;
    &lt;DispatchUserId&gt;E30046&lt;/DispatchUserId&gt;
    &lt;MobileUserId&gt;e19952&lt;/MobileUserId&gt;
  &lt;/MobileUserForcedToSignOff&gt;
  </code></pre>
  
  <p>What I really want, is when I run the query, is for it to return ONLY The DispatchUserID, MessageDate, and MobileUserID.</p>
  
  <p>Any suggestions on how to accomplish this?</p>