[Home] [Help] [Dependency Information]
Object Name: | DBA_ADVISOR_DIR_DEFINITIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
ADVISOR_ID | NUMBER | Yes | ||
ADVISOR_NAME | VARCHAR2 | (128) | Yes | |
DIRECTIVE_NAME | VARCHAR2 | (128) | Yes | |
DOMAIN_NAME | VARCHAR2 | (128) | Yes | |
DESCRIPTION | VARCHAR2 | (256) | Yes | |
TYPE | NUMBER | Yes | ||
TYPE_NAME | VARCHAR2 | (15) | ||
TASK_STATUS | VARCHAR2 | (9) | ||
INSTANCES | VARCHAR2 | (8) | ||
METADATA | CLOB | (4000) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, ADVISOR_ID
, ADVISOR_NAME
, DIRECTIVE_NAME
, DOMAIN_NAME
, DESCRIPTION
, TYPE
, TYPE_NAME
, TASK_STATUS
, INSTANCES
, METADATA
FROM SYS.DBA_ADVISOR_DIR_DEFINITIONS;
|
|
|