select
  inst_id,                                 -- INST_ID NUMBER
  dcrid,                                   -- RECID NUMBER
  dcstm,                                   -- STAMP NUMBER
  dcnam,                                   -- NAME VARCHAR2(513)
  dctag,                                   -- TAG VARCHAR2(32)
  dcdfp,                                   -- FILE# NUMBER
  dcrfn,                                   -- RFILE# NUMBER
  to_number(dccrs),                        -- CREATION_CHANGE# NUMBER
  to_date(                                 -- CREATION_TIME DATE
    dccrt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(dcrls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    dcrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- INCREMENTAL_LEVEL NUMBER
    bitand(dcflg,8),8,0,NULL),
  to_number(dccps),                        -- CHECKPOINT_CHANGE# NUMBER
  to_date(                                 -- CHECKPOINT_TIME DATE
    dccpt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(dcafs),                        -- ABSOLUTE_FUZZY_CHANGE# NUMBER
  to_number(dcrfs),                        -- RECOVERY_FUZZY_CHANGE# NUMBER
  to_date(                                 -- RECOVERY_FUZZY_TIME DATE
    dcrft,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- ONLINE_FUZZY VARCHAR2(3)
    bitand(dcflg, 2),0,'NO','YES'),
  decode(                                  -- BACKUP_FUZZY VARCHAR2(3)
    bitand(dcflg, 4),0,'NO','YES'),
  dcncb,                                   -- MARKED_CORRUPT NUMBER
  dcmcb,                                   -- MEDIA_CORRUPT NUMBER
  dclcb,                                   -- LOGICALLY_CORRUPT NUMBER
  dcbct,                                   -- BLOCKS NUMBER
  dcbsz,                                   -- BLOCK_SIZE NUMBER
  dclor,                                   -- OLDEST_OFFLINE_RANGE NUMBER
  decode(                                  -- DELETED VARCHAR2(3)
    bitand(dcflg, 1),0,'NO','YES'),
  decode(                                  -- STATUS VARCHAR2(1)
    bitand(dcflg, 1+32+64+4096),0,'A',1,'D',32,'X',64,'U', 4096+1,'F','?'),
  to_date(                                 -- COMPLETION_TIME DATE
    dctsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- CONTROLFILE_TYPE VARCHAR2(1)
    dcdfp, 0, decode(bitand(dcflg, 16),16,'S','B'),NULL),
  decode(                                  -- KEEP VARCHAR2(3)
    bitand(dcflg, 1792), 0, 'NO', 'YES'),
  to_date(                                 -- KEEP_UNTIL DATE
    dckpt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- KEEP_OPTIONS VARCHAR2(11)
    bitand(dcflg, 1792), 256, 'LOGS', 512, 'NOLOGS', 1024, 'BACKUP_LOGS', NULL),
  decode(                                  -- SCANNED VARCHAR2(3)
    bitand(dcflg, 128),0,'NO','YES'),
  decode(                                  -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
    bitand(dcflg, 2048),0,'NO','YES'),
  dcrsi,                                   -- RMAN_STATUS_RECID NUMBER
  dcrst,                                   -- RMAN_STATUS_STAMP NUMBER
  decode(                                  -- CONVERTED_FILE VARCHAR2(3)
    bitand(dcflg, 4096),0,'NO','YES'),
  decode(                                  -- SAME_ENDIAN VARCHAR2(3)
    bitand(dcflg, 4096+8192),0,NULL,4096,'NO','YES'),
  dcfdi,                                   -- FOREIGN_DBID NUMBER
  decode(                                  -- PLUGGED_READONLY VARCHAR2(3)
    bitand(dcflg, 16384), 0, 'NO', 'YES'),
  dcplus,                                  -- PLUGIN_CHANGE# NUMBER
  dcprls,                                  -- PLUGIN_RESETLOGS_CHANGE# NUMBER
  dcprlt,                                  -- PLUGIN_RESETLOGS_TIME DATE
  decode(                                  -- BACKED_BY_VSS VARCHAR2(3)
    bitand(dcflg, 32768), 0, 'NO', 'YES') 
from
  x$kccdc