Oracle v8 and higher allows you to specify a table type of "Object", and to base the table on an object or SQLJ object abstract data type, so that the table uses the properties of the ADT and the ADT attributes become table columns.
- Select to open the List of Abstract Data Types, and click the Add a Row tool. Enter a name for the new ADT, and click the Properties tool to open its property sheet.
- Select OBJECT or SQLJ_OBJECT from the Type list to display additional Attributes and Procedures tabs.
- Enter as many attributes and procedures as appropriate.
- Click OK to close the property sheet and return to your model.
Once you have defined your data type, you can base a table on it by opening the table property sheet, selecting Object in the Type field, and then selecting your new data type in the Based on field.