Example 8-5: Describe.xsql explores the Oracle data dictionary

<?xml version="1.0"?>
<xsql:query connection="xmlbook" rowset-element="COLUMNS" row-element="COLUMN"
       tag-case="lower" id-attribute="" xmlns:xsql="urn:oracle-xsql">

  SELECT column_id as id, column_name as name, data_type as "TYPE"
    FROM user_tab_columns
   WHERE table_name = UPPER('{@obj}')
  UNION
  SELECT attr_no as id, attr_name as name, attr_type_name as "TYPE"
    FROM user_type_attrs
   WHERE type_name = UPPER('{@obj}')
   ORDER BY id   

</xsql:query>