Element Type Definition: VIEW

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	VIEW_OBJECT
Short Name	VOB
View Name	CI_VIEW_OBJECTS
Description	A component which manages the retrieval and modification of rows
	of data resulting from a SQL query against one or more entity objects

Sub-type of	CLASSIFIER
Versioning:	Structure of VIEW_OBJECT versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_CLA

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ICON_FILE_REFERENCE	Y	Prompt: Icon File Defined on CLA supertype	May be iconized using one and only one PRIMARY_ACCESS_FILE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
ABSTRACT_FLAG	VARCHAR2(1)	N	Indicates whether the classifier is instantiable. An abstract classifier is not instantiable Prompt: Is Abstract Uppercase Defined on CLA supertype	YESNO	N
AUTHOR	VARCHAR2(100)	Y	Free format text identifying the author Prompt: Author Defined on CLA supertype
CLASSIFIER_SUBTYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether this is an EVENT_CLASSIFIER, GENERIC_CLASS etc Not displayed Uppercase System maintained Not updatable by user Defined on CLA supertype	CLASSIFIER_SUBTYPE
CLASS_NAME	VARCHAR2(100)	N	Name of the Java or C++ class generated for this classifier Prompt: Class Name Defined on CLA supertype
EJB_TARGET_FLAG	VARCHAR2(1)	N	Indicates whether Oracle8i EJB Session Beans is a platform on which this element is deployed. A value of 'Default' indicates the corresponding setting on the owning package applies Prompt: Is Oracle 8i Session Bean Target Uppercase Defined on CLA supertype	YESNODEF	D
EXTERNAL_FLAG	VARCHAR2(1)	N	Indicates whether this is an external class, and therefore not modifiable. Used for standard java library classes Prompt: Is External Uppercase Defined on CLA supertype	YESNO	N
FETCH_MODE	VARCHAR2(9)	N	Indicates how rows are to be fetched from the database Prompt: Fetch Mode Uppercase	FETCH_MODE	AS_NEEDED
FETCH_SIZE	NUMBER(10, 0)	N	Row prefetch size Prompt: Fetch Size		10
FILE_SCOPE	VARCHAR2(10)	N	Indicates whether this is the main classifier in the file, or an inner or subsidiary class Prompt: File Scope Uppercase Defined on CLA supertype	FILE_SCOPE	MAIN
GENERATE_ACCESSORS_FLAG	VARCHAR2(1)	N	Indicates whether accessors are to be generated Prompt: Generate Accessors ? Uppercase	YESNO	Y
IMPLEMENTATION_TARGET	VARCHAR2(13)	Y	Implementation target for the classifier Prompt: Implementation Target Uppercase Defined on CLA supertype	IMPLEMENTATION_TARGET
LEAF_FLAG	VARCHAR2(1)	N	Indicates whether the classifier can be subtyped. If a leaf, it is not allowed to have subtypes Prompt: Is Leaf Uppercase Defined on CLA supertype	YESNO	N
MAX_FETCH_SIZE	NUMBER(10, 0)	N	Maximum number of rows to be fetched during query processing. A value of 0 indicates there is no maximum to the number of rows fetched (this is as specified by BC4J) Prompt: Maximum Fetch Size		0
NAME	VARCHAR2(100)	N	Name of the classifier Prompt: Name Defined on CLA supertype
O8I_TARGET_FLAG	VARCHAR2(1)	N	Indicates whether Oracle8i is a platform on which this element is deployed. A value of 'Default' indicates the corresponding setting on the owning package applies Prompt: Is Oracle8i Target Uppercase Defined on CLA supertype	YESNODEF	D
ROOT_FLAG	VARCHAR2(1)	N	Indicates whether the classifier can have supertypes. If a root, it is not allowed to have supertypes Prompt: Is Root Uppercase Defined on CLA supertype	YESNO	N
SYSTEM_ELEMENT_FLAG	VARCHAR2(1)	N	Indicates whether this is a "system element", ie one created by the API that the user cannot subsequently delete Not displayed Uppercase Defined on CLA supertype	YESNO	N
VISIBROKER_TARGET_FLAG	VARCHAR2(1)	N	Indicates whether Visigenics Visibroker is a platform on which this element is deployed. A value of 'Default' indicates the corresponding setting on the owning package applies Prompt: Is Visigenics Visibroker Target Uppercase Defined on CLA supertype	YESNODEF	D

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC Defined on CLA supertype	Description
FROM_CLAUSE	FROMCL	From Clause
GROUP_BY_CLAUSE	GRBYCL	Group By Clause
NOTES	CDINOT Defined on CLA supertype	Notes
ORDER_BY_CLAUSE	ORBYCL	Order By Clause
SELECT_LIST	LGEXPR	Select List
WHERE_CLAUSE	WHERCL	Where Clause

Other Properties
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference VIEW_OBJECT:

Each ASSOCIATION_END may be a collection defined by one and only one CLASSIFIER
Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each CLASSIFIER_ATTRIBUTE may be of datatype of one and only one CLASSIFIER
Each CLASSIFIER_GENERALIZATION must be with subtype of one and only one CLASSIFIER
Each CLASSIFIER_GENERALIZATION must be with supertype of one and only one CLASSIFIER
Each EVENT_PUBLICATION must be for publication by one and only one CLASSIFIER
Each INTERFACE_USAGE must be a usage in one and only one CLASSIFIER
Each CLASSIFIER_RULE must be applied to one and only one VIEW_OBJECT (in arc)
Each CLASSIFIER_SPEC_GROUP must be for one and only one CLASSIFIER
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each ENTITY_OBJECT_USAGE must be a usage in one and only one VIEW_OBJECT
Each ELEMENT_RULE_USAGE must be applicable to one and only one CIELEMENT (in arc)
Each EVENT_SUBSCRIPTION must be by one and only one CLASSIFIER
Each FILE_USAGE must be a usage by one and only one CLASSIFIER (in arc)
Each FILE_SECTION must be a section of code for one and only one CLASSIFIER
Each GENERAL_ATTRIBUTE may be a collection defined by one and only one CLASSIFIER
Each GENERIC_CLASS may be with primary class of one and only one CLASSIFIER
Each INTERFACE_CLASSIFIER may be with primary class of one and only one CLASSIFIER
Each METHOD may be of collection return type defined by one and only one CLASSIFIER
Each METHOD may be with return type defined by one and only one CLASSIFIER
Each METHOD must be defined in one and only one CLASSIFIER
Each METHOD_PARAMETER may be a collection defined by one and only one CLASSIFIER
Each METHOD_PARAMETER may be of datatype of one and only one CLASSIFIER
Each OBJECT_STATE must be representing a state of one and only one CLASSIFIER (in arc)
Each PACKAGE may be represented by one and only one CLASSIFIER
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each TAGGED_VALUE must be in the context of one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_CLIENT must be identifying as client one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_SUPPLIER must be identifying as supplier one and only one CIELEMENT (in arc)
Each VIEW_LINK_END must be on one and only one VIEW_OBJECT
Each VIEW_OBJECT_ATTRIBUTE must be defined in one and only one VIEW_OBJECT
Each VIEW_USAGE must be a usage of one and only one VIEW_OBJECT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype