Object (or SQLJ object) data types

Chapter 15 DBMS-Specific Features

Object (or SQLJ object) data types

DBMS Oracle 8 (or higher)

If you are working with Oracle 8 (or higher) as the target DBMS, and you select a table type of "Object", then the table property sheet General tab will include the property "Based On".

You can assign object (or SQLJ object) abstract data types to tables in Oracle. Object (or SQLJ object) ADT are data types of the type Object (or SQLJ Object). When you assign an object (or SQLJ object) ADT to a table, the table uses the properties of the ADT and the ADT attributes become table columns.

For more information on Oracle 8 abstract data types, see the corresponding Oracle 8 documentation.

To create an object (or SQLJ object) data type and use it in a table:

Select Model→Abstract Data Types to display the List of Abstract Data Types.

Click a new line in the list.

or

Click the Add a Row tool.

An arrow is displayed at the beginning of the line.

Type an abstract data type name and code.

Click Apply to commit the creation of the new abstract data type.

Click the Properties tool.

or

Double-click the arrow at the beginning of the line.

The abstract data type property sheet opens to the General tab.

Select OBJECT (or SQLJ_OBJECT) from the Type dropdown list box.

The Attributes and Procedures tabs appear in the abstract data type property sheet.

Click the Attributes tab to display the Attributes tab.

Click a blank line in the list.

Type an attribute Name and Code.

Select a data type class from the Data Type dropdown list box.

Display the column you need
If you do not see the column you need, display it with the Customize Columns and Filter tool.

Repeat steps 8 to 10 for every object (or SQLJ object) attribute you want to define.

Click OK in each of the dialog boxes.

Double-click a table in the model to display its property sheet.

Select the new object (or SQLJ object) data type from the Based on dropdown list box.

Click OK.