Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | RELATION_SELECTION |
| Short Name | VWTAB |
| View Name | CI_RELATION_SELECTIONS |
| Description | An underlying table, view or snapshot used in the definition of a view |
| or snapshot | |
| Sub-type of | INTERSECTION |
| Versioning: | Belongs to: RECORD versionable object SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object VIEW_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
VIEW_REFERENCE TABLE_REFERENCE ALIAS |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_VWTAB |
| Changes: | Summary of changes to RELATION_SELECTION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| TABLE_REFERENCE | N |
Prompt: Table
Transferable only if null |
Must be of one and only one RELATION_DEFINITION | |
| VIEW_REFERENCE | N |
Prompt: View
Transferable only if null |
Must be in one and only one RELATION_DEFINITION | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ALIAS | VARCHAR2(30) | Y | An alias for the table/view to qualify columns in the SELECT and WHERE clause.
Prompt: Alias Uppercase | ||
| SEQUENCE_NUMBER | NUMBER(6, 0) | N | A sequence number to place the table/view in the correct order in this view.
Prompt: Usage Sequence System maintained: API provides a value only if left null by the user | ||
| SUBQUERY_USAGE_FLAG | VARCHAR2(1) | N | Y indicates the table is used within a sub-query of the WHERE clause of the view
Prompt: Used in Sub-Query ? Uppercase | YESNO | N |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Common repository version identifier of owning PAC
Not displayed System maintained Updatable only if null Defined on SE supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed System maintained Not updatable by user Defined on SE supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
| RELATION_SELECTION has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference RELATION_SELECTION:
Note: