JAVA J2EE 4 U

 SET LINESIZE 200

COL backup_type FOR A15

COL avg_duration_mins FOR 20

COL total_backups FOR 15

SELECT 

    DECODE(b.incremental_level, 

           NULL, 'FULL', 

           0, 'LEVEL 0 INCR', 

           1, 'LEVEL 1 INCR', 

           'OTHER') AS backup_type,

    ROUND(AVG((b.completion_time - b.start_time) * 24 * 60), 2) AS avg_duration_mins,

    COUNT(*) AS total_backups

FROM 

    v$backup_set b

WHERE 

    b.start_time >= SYSDATE - 7  -- Change as needed

GROUP BY 

    DECODE(b.incremental_level, 

           NULL, 'FULL', 

           0, 'LEVEL 0 INCR', 

           1, 'LEVEL 1 INCR', 

           'OTHER')

ORDER BY 

    backup_type;