|
|
|
The information from TARGET_DBMS is broken down into DBMS-specific tables to make some queries easier. Each of these tables is named in the form XX_DBMS where XX is the name of the DBMS.
The following table describes the columns in the DBMS-specific tables:
|
Column Name |
Data Type |
Description |
|---|---|---|
|
TYPE |
INTEGER |
The ID of an object type, property type, association type, or aggregation type. |
|
MIN_VERSION |
INTEGER |
The earliest version for which the type is defined. The format is the version number multiplied by 1000. For example, Version 7.2 would be 7200. A value of zero indicates all versions less than MAX_VERSION. |
|
MAX_VERSION |
INTEGER |
The latest version for which the type is defined. The format is the version number multiplied by 1000. For example, Version 7.2 would be 7200. A value of 999000 indicates all versions greater than MIN_VERSION. |
You can use a query similar to the following to determine the objects that are defined for Oracle.
Example: Query for returning a list of the objects defined for Oracle
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |