Example 8-7: Querying the data dictionary for column type information

<?xml version = '1.0'?>
<columns>
   <column>
      <id>1</id>
      <name>STREET</name>
      <type>VARCHAR2</type>
   </column>
   <column>
      <id>2</id>
      <name>CITY</name>
      <type>VARCHAR2</type>
   </column>
   <column>
      <id>3</id>
      <name>STATE</name>
      <type>VARCHAR2</type>
   </column>
   <column>
      <id>4</id>
      <name>POSTCODE</name>
      <type>VARCHAR2</type>
   </column>
   <column>
      <id>5</id>
      <name>COUNTRY</name>
      <type>VARCHAR2</type>
   </column>
</columns>