Filter
Top Products
1656 Brocade Network Advisor IP User Manual
53-1003056-01
Views
I
TIME_SERIES_DATA_1_2HOUR.MEASURE_ID,
TIME_SERIES_DATA_1_2HOUR.TARGET_ID,
TIME_SERIES_DATA_1_2HOUR.COLLECTOR_ID,
TIME_SERIES_DATA_1_2HOUR.MEASURE_INDEX,
TIME_SERIES_DATA_1_2HOUR.ME_ID,
TIME_SERIES_DATA_1_2HOUR.VALUE,
TIME_SERIES_DATA_1_2HOUR.SUM_VALUE
from TIME_SERIES_DATA_1_2HOUR)
union all
select TIME_SERIES_DATA_1_1DAY.TIME_IN_SECONDS,
TIME_SERIES_DATA_1_1DAY.TARGET_TYPE,
TIME_SERIES_DATA_1_1DAY.MEASURE_ID,
TIME_SERIES_DATA_1_1DAY.TARGET_ID,
TIME_SERIES_DATA_1_1DAY.COLLECTOR_ID,
TIME_SERIES_DATA_1_1DAY.MEASURE_INDEX,
TIME_SERIES_DATA_1_1DAY.ME_ID,
TIME_SERIES_DATA_1_1DAY.VALUE,
TIME_SERIES_DATA_1_1DAY.SUM_VALUE
from TIME_SERIES_DATA_1_1DAY)
union all
select * from TIME_SERIES_DATA_2)
union all
select TIME_SERIES_DATA_2_30MIN.TIME_IN_SECONDS,
TIME_SERIES_DATA_2_30MIN.TARGET_TYPE,
TIME_SERIES_DATA_2_30MIN.MEASURE_ID,
TIME_SERIES_DATA_2_30MIN.TARGET_ID,
TIME_SERIES_DATA_2_30MIN.COLLECTOR_ID,
TIME_SERIES_DATA_2_30MIN.MEASURE_INDEX,
TIME_SERIES_DATA_2_30MIN.ME_ID,
TIME_SERIES_DATA_2_30MIN.VALUE,
TIME_SERIES_DATA_2_30MIN.SUM_VALUE
from TIME_SERIES_DATA_2_30MIN)
union all
select TIME_SERIES_DATA_2_2HOUR.TIME_IN_SECONDS,
TIME_SERIES_DATA_2_2HOUR.TARGET_TYPE,
TIME_SERIES_DATA_2_2HOUR.MEASURE_ID,
TIME_SERIES_DATA_2_2HOUR.TARGET_ID,
TIME_SERIES_DATA_2_2HOUR.COLLECTOR_ID,
TIME_SERIES_DATA_2_2HOUR.MEASURE_INDEX,
TIME_SERIES_DATA_2_2HOUR.ME_ID,
TIME_SERIES_DATA_2_2HOUR.VALUE,
TIME_SERIES_DATA_2_2HOUR.SUM_VALUE
from TIME_SERIES_DATA_2_2HOUR)
union all
select TIME_SERIES_DATA_2_1DAY.TIME_IN_SECONDS,
TIME_SERIES_DATA_2_1DAY.TARGET_TYPE,
TIME_SERIES_DATA_2_1DAY.MEASURE_ID,
TIME_SERIES_DATA_2_1DAY.TARGET_ID,
TIME_SERIES_DATA_2_1DAY.COLLECTOR_ID,
TIME_SERIES_DATA_2_1DAY.MEASURE_INDEX,
TIME_SERIES_DATA_2_1DAY.ME_ID,
TIME_SERIES_DATA_2_1DAY.VALUE,
TIME_SERIES_DATA_2_1DAY.SUM_VALUE
from TIME_SERIES_DATA_2_1DAY
TIME_SERIES_DATA_VIEW
create or replace view TIME_SERIES_DATA_VIEW as