Chapter 15 DBMS-Specific Features

Object and SQLJ object data types

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.


For more information on ADTs, see your Oracle documentation.

Steps To create an object (or SQLJ object) data type:

  1. Select Model→Abstract Data Types to open the List of Abstract Data Types, and then click the Add a Row tool and enter a name for the new ADT.
  2. Click the Properties tool to open the new ADT property sheet.
  3. Select OBJECT or SQLJ_OBJECT from the Type list.

    Additional Attributes and Procedures tabs will be displayed in the ADT property sheet.
  4. Click the Attributes tab, and then click the Add a Row tool:
  5. Specify a name and code, and select a data type from the list.

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

  6. Add additional attributes as necessary, and then click OK to close each of the property sheets.

When you have created your new data type, you can base tables on it.

Steps To base a table on an object (or SQLJ object) data type:

  1. Open a table property sheet, and select Object in the Type list.
  2. Select the new object (or SQLJ object) data type in the Based on list.
  3. Click Ok to close the property sheet and return to your model.

 

Copyright (C) 2007. Sybase Inc. All rights reserved.