select d.dbid,
d.snap_id,
c.cellhash cell_hash,
extractvalue(xmltype(c.confval),'/cli-output/cell/name') cell_name,
decode(d.con_dbid, 0, d.dbid, d.con_dbid) con_dbid,
0 con_id
from wrh$_cell_config_detail d,
wrh$_cell_config c
where d.dbid = c.dbid
and d.cellhash = c.cellhash
and d.conftype = c.conftype
and d.confval_hash = c.confval_hash
and c.conftype = 'CELL'
SELECT D.DBID
,
D.SNAP_ID
,
C.CELLHASH CELL_HASH
,
EXTRACTVALUE(XMLTYPE(C.CONFVAL)
, '/CLI-OUTPUT/CELL/NAME') CELL_NAME
,
DECODE(D.CON_DBID
, 0
, D.DBID
, D.CON_DBID) CON_DBID
,
0 CON_ID
FROM WRH$_CELL_CONFIG_DETAIL D
,
WRH$_CELL_CONFIG C
WHERE D.DBID = C.DBID
AND D.CELLHASH = C.CELLHASH
AND D.CONFTYPE = C.CONFTYPE
AND D.CONFVAL_HASH = C.CONFVAL_HASH
AND C.CONFTYPE = 'CELL'
|
|
|