Identify which tapes needed for recovery

Look at media column to identify the tapes

col handle for a40

col media for a30

 SELECT   piece#, tag, media, handle,

    TO_CHAR (start_time, 'DD-MON-YYYY HH24:MI:SS') AS start_time,

    TO_CHAR (completion_time, 'DD-MON-YYYY HH24:MI:SS') AS completion_time

   FROM rc_backup_piece

    WHERE start_time >= TO_DATE ('14-MAR-2013 00:00:00', 'dd-mon-yyyy HH24:MI:SS')

    AND completion_time < TO_DATE ('16-MAR-2013 00:00:00', 'dd-mon-yyyy HH24:MI:SS')

    ORDER BY 1;