select
  inst_id,                                 -- INST_ID NUMBER
  dlrid,                                   -- RECID NUMBER
  dlstm,                                   -- STAMP NUMBER
  decode(                                  -- TYPE VARCHAR2(26)
    dltyp,11,'ARCHIVED LOG',13,'BACKUP PIECE',16,'DATAFILE COPY',20,'PROXY COPY',34,'RESTORE POINT',35,'DATABASE BLOCK CORRUPTION', 37,'FOREIGN ARCHIVED LOG', 255,'BACKUP PIECE AVAILABLE',254,'BACKUP PIECE EXPIRED',253,'PROXY COPY AVAILABLE',252,'PROXY COPY EXPIRED',251,'BACKUP PIECE UNAVAILABLE',250,'PROXY COPY UNAVAILABLE',249,'DATAFILE COPY AVAILABLE',248,'DATAFILE COPY EXPIRED',247,'DATAFILE COPY UNAVAILABLE',246,'ARCHIVED LOG AVAILABLE',245,'ARCHIVED LOG EXPIRED',244,'ARCHIVED LOG UNAVAILABLE',243,'BACKUP SET KEEP OPTIONS',242,'BACKUP SET KEEP UNTIL',241,'PROXY COPY KEEP OPTIONS',240,'PROXY COPY KEEP UNTIL',239,'DATAFILE COPY KEEP OPTIONS',238,'DATAFILE COPY KEEP UNTIL',237,'DATAFILE RENAME ON RESTORE',236,'TEMPFILE RENAME', 235,'PREVIOUS PIECE BACKUP SET', 234,'PLUGGED READONLY RENAME', 233,'BACKUP RECORD CLEANUP', 'UNKNOWN'),
  dlobp,                                   -- OBJECT_RECID NUMBER
  dlosm,                                   -- OBJECT_STAMP NUMBER
  dltsd,                                   -- OBJECT_DATA NUMBER
  decode(                                  -- SET_STAMP NUMBER
    dlbss, 0, to_number(NULL), dlbss),
  decode(                                  -- SET_COUNT NUMBER
    dlbss, 0, to_number(NULL), dlbsc) 
from
  x$kccdl