SQL & PL/SQL

Hello all,   ( v12.1)

Just trying to build some queries and would like to add the database name ( from v$database) for each row displayed.

column StartTime format a15

column EndTime format a15

select to_char(start_time,'DD-MON HH24:MI') StartTime,

   to_char(end_time,'DD-MON HH24:MI') EndTime,

   (end_time-start_time)*1440 Mins,

   input_type, status

   from v$rman_backup_job_details

  where start_time > sysdate - 1

  and input_type='DB FULL'

  order by start_time;

26-JUN 17:00           26-JUN 17:05            5.63333333            DB FULL                  COMPLETED

like this

MY DATABASE       26-JUN 17:00           26-JUN 17:05            5.63333333            DB FULL                  COMPLETED

Thanks