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
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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment