select
  inst_id,                                 -- INST_ID NUMBER
  fcrid,                                   -- RECID NUMBER
  fcstm,                                   -- STAMP NUMBER
  fcbss,                                   -- SET_STAMP NUMBER
  fcbsc,                                   -- SET_COUNT NUMBER
  fcpno,                                   -- PIECE# NUMBER
  fcdfp,                                   -- FILE# NUMBER
  fcblk,                                   -- BLOCK# NUMBER
  fccnt,                                   -- BLOCKS NUMBER
  to_number(fcscn),                        -- CORRUPTION_CHANGE# NUMBER
  decode(                                  -- MARKED_CORRUPT VARCHAR2(3)
    bitand(fcflg,1),1,'YES','NO'),
  decode(                                  -- CORRUPTION_TYPE VARCHAR2(9)
    bitand(fcflg,30),2,'ALL ZERO',4,'FRACTURED',8,'CHECKSUM', 16,'CORRUPT', 32, 'NOLOGGING', 64, 'LOGICAL', 'UNKNOWN') 
from
  x$kccfc