set lines 180 pages 500
col end_time for a25
col start_time for a25

SELECT
  * 
FROM
  (
    SELECT
      SESSION_KEY,
      INPUT_TYPE,
      STATUS,
      OUTPUT_DEVICE_TYPE AS DEVICE_TYPE,
      to_char(START_TIME, 'dd/mm/yy hh24:mi') start_time,
      to_char(END_TIME, 'dd/mm/yy hh24:mi') end_time,
      elapsed_seconds / 3600 hrs 
    FROM
      V$RMAN_BACKUP_JOB_DETAILS 
    ORDER BY
      session_key DESC
  )
WHERE
  rownum < 100
/