select
  inst_id,                                 -- INST_ID NUMBER
  ccrid,                                   -- RECID NUMBER
  ccstm,                                   -- STAMP NUMBER
  ccdcp,                                   -- COPY_RECID NUMBER
  ccdcs,                                   -- COPY_STAMP NUMBER
  ccdfp,                                   -- FILE# NUMBER
  ccblk,                                   -- BLOCK# NUMBER
  cccnt,                                   -- BLOCKS NUMBER
  to_number(ccscn),                        -- CORRUPTION_CHANGE# NUMBER
  decode(                                  -- MARKED_CORRUPT VARCHAR2(3)
    bitand(ccflg,1),1,'YES','NO'),
  decode(                                  -- CORRUPTION_TYPE VARCHAR2(9)
    bitand(ccflg,30),2,'ALL ZERO',4,'FRACTURED',8,'CHECKSUM', 16,'CORRUPT', 32, 'NOLOGGING', 64, 'LOGICAL', 'UNKNOWN') 
from
  x$kcccc