[Home] [Help] [Dependency Information]
Object Name: | JTF_DIAGNOSTIC_KB# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE | NUMBER | (15) | Yes | |
USER_TEST_NAME | VARCHAR2 | (500) | Yes | |
METALINK_NOTE | VARCHAR2 | (1000) | ||
COMPETENCY | VARCHAR2 | (500) | Yes | |
SUBCOMPETENCY | VARCHAR2 | (1500) | Yes | |
PRODUCTS | VARCHAR2 | (1000) | ||
TEST_TYPE | VARCHAR2 | (1000) | Yes | |
ANALYSIS_SCOPE | VARCHAR2 | (1000) | ||
DESCRIPTION | VARCHAR2 | (2000) | ||
SHORT_DESCR | VARCHAR2 | (160) | ||
USAGE_DESCR | VARCHAR2 | (1000) | Yes | |
KEYWORDS | VARCHAR2 | (1000) | Yes | |
COMPONENT | VARCHAR2 | (500) | ||
SUBCOMPONENT | VARCHAR2 | (500) | ||
HIGH_PRODUCT_VERSION | VARCHAR2 | (100) | ||
LOW_PRODUCT_VERSION | VARCHAR2 | (100) | ||
HIGH_PATCHSET | VARCHAR2 | (100) | ||
LOW_PATCHSET | VARCHAR2 | (100) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
SECURITY_GROUP_ID | NUMBER | |||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SEQUENCE
, USER_TEST_NAME
, METALINK_NOTE
, COMPETENCY
, SUBCOMPETENCY
, PRODUCTS
, TEST_TYPE
, ANALYSIS_SCOPE
, DESCRIPTION
, SHORT_DESCR
, USAGE_DESCR
, KEYWORDS
, COMPONENT
, SUBCOMPONENT
, HIGH_PRODUCT_VERSION
, LOW_PRODUCT_VERSION
, HIGH_PATCHSET
, LOW_PATCHSET
, OBJECT_VERSION_NUMBER
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM JTF.JTF_DIAGNOSTIC_KB#;
|
|
|