Example 8-12: Querying website categories from a table

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="SiteMenu.xsl"?>
<website connection="xmlbook" xmlns:xsql="urn:oracle-xsql">
    <xsql:query rowset-element="categories" row-element="category"
                tag-case="lower">

      SELECT name, icon, url
        FROM site_category
       ORDER BY pos

    </xsql:query>
</website>