<?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> |