Database columns and types

The Database Interface Designer and mtsmaker with the Type Tree Maker generate type trees for queries, tables, views, and stored procedures in an Oracle-compliant DBMS (Database Management System). Item types will be created in a type tree that represent the data types of the columns of a query, table, view, or stored procedure.

The Database Interface Designer and mtsmaker get information about columns by calling Oracle to describe the columns associated with a query, table, view, or stored procedure. Oracle returns the data type, length, and other information to the Database Interface Designer and mtsmaker. The Database Interface Designer and mtsmaker then map the Oracle data types to item types in a type tree.