Search SSWUG.ORG:



DEVELOPMENT

Using XQuery To Access XML And Relational Data


This article provides an example of how you might query both XML and relational data within a single SQL query using Oracle XQuery, demonstrating the Oracle Database’s ability to combine together different format data. In particular, you’ll look at a query that retrieves data from the DEPARTMENTS relational table in the HR sample schema and an XML document you’ll create on the fly, putting there information about employees.


Read this article..







comments powered by Disqus