[Home] [Help] [Dependency Information]
Object Name: | BIM_I_SGMT_FACTS# |
---|---|
Object Type: | VIEW |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_CREATE_DATE | DATE | |||
SEGMENT_ID | NUMBER | |||
METRIC_TYPE | VARCHAR2 | (10) | ||
SEGMENT_SIZE | NUMBER | |||
SEGMENT_STATUS | VARCHAR2 | (30) | ||
CUST_COUNT_WEEK | NUMBER | |||
CUST_COUNT_MONTH | NUMBER | |||
CUST_COUNT_QTR | NUMBER | |||
CUST_COUNT_YEAR | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_CREATE_DATE
, SEGMENT_ID
, METRIC_TYPE
, SEGMENT_SIZE
, SEGMENT_STATUS
, CUST_COUNT_WEEK
, CUST_COUNT_MONTH
, CUST_COUNT_QTR
, CUST_COUNT_YEAR
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM BIM.BIM_I_SGMT_FACTS#;
|
|
|