[Home] [Help] [Dependency Information]
Object Name: | CN_OBJECTS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | CN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | (15) | Yes | |
DEPENDENCY_MAP_COMPLETE | VARCHAR2 | (1) | Yes | |
NAME | VARCHAR2 | (30) | Yes | |
OBJECT_TYPE | VARCHAR2 | (15) | Yes | |
REPOSITORY_ID | NUMBER | (15) | Yes | |
OBJECT_STATUS | VARCHAR2 | (1) | Yes | |
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
DESCRIPTION | VARCHAR2 | (1900) | ||
NEXT_SYNCHRONIZATION_DATE | DATE | |||
SYNCHRONIZATION_FREQUENCY | VARCHAR2 | (30) | ||
DATA_LENGTH | NUMBER | (15) | ||
DATA_TYPE | VARCHAR2 | (9) | ||
NULLABLE | VARCHAR2 | (1) | ||
PRIMARY_KEY | VARCHAR2 | (1) | ||
POSITION | NUMBER | (15) | ||
DIMENSION_ID | NUMBER | (15) | ||
DATA_SCALE | NUMBER | (15) | ||
COLUMN_TYPE | VARCHAR2 | (4) | ||
TABLE_ID | NUMBER | (15) | ||
UNIQUE_FLAG | VARCHAR2 | (1) | ||
PACKAGE_TYPE | VARCHAR2 | (4) | ||
PACKAGE_SPECIFICATION_ID | NUMBER | (15) | ||
PARAMETER_LIST | VARCHAR2 | (1900) | ||
RETURN_TYPE | VARCHAR2 | (9) | ||
PROCEDURE_TYPE | VARCHAR2 | (1) | ||
PACKAGE_ID | NUMBER | (15) | ||
START_VALUE | NUMBER | (15) | ||
INCREMENT_VALUE | NUMBER | (15) | ||
ALIAS | VARCHAR2 | (30) | ||
TABLE_LEVEL | VARCHAR2 | (1) | ||
TABLE_TYPE | VARCHAR2 | (1) | ||
WHEN_CLAUSE | VARCHAR2 | (255) | ||
TRIGGERING_EVENT | VARCHAR2 | (1) | ||
EVENT_ID | NUMBER | (15) | ||
PUBLIC_FLAG | VARCHAR2 | (1) | ||
CHILD_FLAG | VARCHAR2 | (1) | ||
FOR_EACH_ROW | VARCHAR2 | (1) | ||
TRIGGER_TYPE | VARCHAR2 | (1) | ||
USER_COLUMN_NAME | VARCHAR2 | (1) | ||
SEED_OBJECT_ID | NUMBER | (15) | ||
PRIMARY_KEY_COLUMN_ID | NUMBER | (15) | ||
USER_NAME_COLUMN_ID | NUMBER | (15) | ||
CONNECT_TO_USERNAME | VARCHAR2 | (30) | ||
CONNECT_TO_PASSWORD | VARCHAR2 | (30) | ||
CONNECT_TO_HOST | VARCHAR2 | (255) | ||
USER_NAME | VARCHAR2 | (30) | ||
SCHEMA | VARCHAR2 | (30) | ||
FOREIGN_KEY | VARCHAR2 | (1) | ||
CLASSIFICATION_COLUMN | VARCHAR2 | (1) | ||
CALC_FORMULA_FLAG | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | (15) | ||
CALC_ELIGIBLE_FLAG | VARCHAR2 | (1) | ||
COLUMN_DATATYPE | VARCHAR2 | (30) | ||
VALUE_SET_ID | NUMBER | (15) | ||
OBJECT_VALUE | VARCHAR2 | (1900) | ||
CUSTOM_CALL | VARCHAR2 | (240) | ||
SECURITY_GROUP_ID | NUMBER | |||
STATEMENT_TEXT | CLOB | (4000) | ||
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | |
DISPLAY_COLUMN | VARCHAR2 | (1) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_ID
, DEPENDENCY_MAP_COMPLETE
, NAME
, OBJECT_TYPE
, REPOSITORY_ID
, OBJECT_STATUS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, NEXT_SYNCHRONIZATION_DATE
, SYNCHRONIZATION_FREQUENCY
, DATA_LENGTH
, DATA_TYPE
, NULLABLE
, PRIMARY_KEY
, POSITION
, DIMENSION_ID
, DATA_SCALE
, COLUMN_TYPE
, TABLE_ID
, UNIQUE_FLAG
, PACKAGE_TYPE
, PACKAGE_SPECIFICATION_ID
, PARAMETER_LIST
, RETURN_TYPE
, PROCEDURE_TYPE
, PACKAGE_ID
, START_VALUE
, INCREMENT_VALUE
, ALIAS
, TABLE_LEVEL
, TABLE_TYPE
, WHEN_CLAUSE
, TRIGGERING_EVENT
, EVENT_ID
, PUBLIC_FLAG
, CHILD_FLAG
, FOR_EACH_ROW
, TRIGGER_TYPE
, USER_COLUMN_NAME
, SEED_OBJECT_ID
, PRIMARY_KEY_COLUMN_ID
, USER_NAME_COLUMN_ID
, CONNECT_TO_USERNAME
, CONNECT_TO_PASSWORD
, CONNECT_TO_HOST
, USER_NAME
, SCHEMA
, FOREIGN_KEY
, CLASSIFICATION_COLUMN
, CALC_FORMULA_FLAG
, ORG_ID
, CALC_ELIGIBLE_FLAG
, COLUMN_DATATYPE
, VALUE_SET_ID
, OBJECT_VALUE
, CUSTOM_CALL
, SECURITY_GROUP_ID
, STATEMENT_TEXT
, OBJECT_VERSION_NUMBER
, DISPLAY_COLUMN
, ZD_EDITION_NAME
FROM CN.CN_OBJECTS_ALL#;
|
|
|