Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | VIEW_DEFINITION |
| Short Name | VW |
| View Name | CI_VIEW_DEFINITIONS |
| Description | Definition of a relational or object view |
| An object view is distinguished by the fact that its relationship | |
| to ORACLE_OBJECT_TYPE is populated | |
| Sub-type of | RELATION_DEFINITION |
| Versioning: | Structure of VIEW_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_TAB |
| Changes: | Summary of changes to VIEW_DEFINITION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ORACLE_OBJECT_TYPE_REFERENCE | Y | Prompt: Object Type | May be an object view of one and only one ORACLE_OBJECT_TYPE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ALIAS | VARCHAR2(10) | Y | The unique alias for the view name
Prompt: Alias Uppercase | ||
| COLUMN_PREFIX | VARCHAR2(4) | Y | A prefix for the columns for this view.
Prompt: Col. Prefix Uppercase | ||
| DISPLAY_TITLE | VARCHAR2(132) | Y | The title of this view to be used in screens, reports etc
Prompt: Display Title | ||
| NAME | VARCHAR2(30) | N | The unique table name.
Prompt: Name Uppercase Defined on TAB supertype | ||
| OID_ATTRIBUTE_LIST | VARCHAR2(2000) | Y | Comma separated list of attributes of the object type that will be used as a key to uniquely identify each row in the object view
Prompt: OID Attribute List Uppercase | ||
| OVERRIDE_SELECT_TEXT_FLAG | VARCHAR2(1) | N | Indicates whether (Y) or not (N) the SELECT information is to be free format
Prompt: Free Format Select Text ? Uppercase | YESNO | N |
| REMARK | VARCHAR2(2000) | Y | A brief comment about this table, view, snapshot or record
Prompt: Comment Defined on TAB supertype | ||
| SAMPLE_PERCENT | NUMBER(8, 6) | Y | Applicable to SAMPLE clause, indicating the size of the sample as a percentage
Not displayed Range: 0.000001 to 99 | ||
| SAMPLE_TYPE | VARCHAR2(12) | Y | Applicable to the SAMPLE clause, allowing user to specify whether the results of the query are to be based on a random row or block sample of the whole table
Not displayed Uppercase | SAMPLE_TYPE | |
| TABLE_TYPE | VARCHAR2(6) | Y | Sub-type discriminator. Internal property indicating whether the RELATION_DEFINITION is a TABLE_DEFINITION (TABLE), VIEW_DEFINITION (VIEW), RECORD (RECORD), or SNAPSHOT_DEFINITION (SNAP).
Not displayed Uppercase System maintained Not updatable by user Defined on TAB supertype | TAB_TABLE_TYPE | |
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DELETE_TEXT | CGTDEL | Delete Code |
| DESCRIPTION | CDIDSC | Description |
| EXPRESSION | LGEXPR | Select Text |
| HELP | CDHELP | User/Help Text |
| INSERT_TEXT | CGTINS | Insert Code |
| LOCK_TEXT | CGTLCK | Lock Code |
| NOTES | CDINOT | Notes |
| OPTIMIZER_HINT | DBHINT | Optimizer Hint Clause |
| UPDATE_TEXT | CGTUPD | Update Code |
| WHERE_CLAUSE | CDWHCL | Where/Validation Condition |
| Other Properties |
|---|
| VIEW_DEFINITION 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 VIEW_DEFINITION:
Note: