Monday, May 16, 2011

Using XPath with Oracle XMLType

Example below shows the extraction of details from an Oracle AQ queue with datatype of XML Type using XPath.


SELECT
     w.user_data.extract('//m:DeclarationNo/text()', 'xmlns:m="http://namespace/DPWClearance/2.1"').getStringVal() "DeclarationNo"
  FROM CLEARANCE_QTAB w ORDER BY ENQ_TIME DESC