FAI_SAM_TBS_OCTO_METRIC

Details

Schema: FUSION
Object owner: FAI
Object type: VIEW

Columns

Name
METRIC_ID KEY VALUE TYPE DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID OBJECT_VERSION_NUMBER

Name

METRIC_ID

KEY

VALUE

TYPE

DESCRIPTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ENTERPRISE_ID

OBJECT_VERSION_NUMBER

Query

SQL_Statement
select "METRIC_ID","KEY","VALUE","TYPE","DESCRIPTION","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","ENTERPRISE_ID","OBJECT_VERSION_NUMBER" from FAI_SAM_METRIC where last_update_date >= SYS_EXTRACT_UTC(SYSTIMESTAMP) - interval '1' day

SQL_Statement

select "METRIC_ID","KEY","VALUE","TYPE","DESCRIPTION","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","ENTERPRISE_ID","OBJECT_VERSION_NUMBER" from FAI_SAM_METRIC

where last_update_date >= SYS_EXTRACT_UTC(SYSTIMESTAMP) - interval '1' day