select SNAP_ID, DBID, INSTANCE_NUMBER, CON_DBID, COMPONENT_ID, COMPONENT_NAME,
BAND_START_TIME, BAND_LENGTH, REPORT_ID, REPORT_GENERATION_TIME,
PERIOD_START_TIME, PERIOD_END_TIME, KEY1, KEY2, KEY3, KEY4, SESSION_ID,
SESSION_SERIAL#, nvl(con_dbid_to_id(con_dbid), 0) CON_ID
from wrp$_reports_time_bands
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, CON_DBID
, COMPONENT_ID
, COMPONENT_NAME
,
BAND_START_TIME
, BAND_LENGTH
, REPORT_ID
, REPORT_GENERATION_TIME
,
PERIOD_START_TIME
, PERIOD_END_TIME
, KEY1
, KEY2
, KEY3
, KEY4
, SESSION_ID
,
SESSION_SERIAL#
, NVL(CON_DBID_TO_ID(CON_DBID)
, 0) CON_ID
FROM WRP$_REPORTS_TIME_BANDS
|
|
|