Database Software

hi folks,

Im trying to get a L0 backup history for a database, my query is:

SELECT bj.db_name,

         bj.status,

         INPUT_TYPE||' '||i.INCREMENTAL_LEVEL "BACKUP_TYPE",
        to_char(bj.START_TIME,'mm/dd/yy hh24:mi') "START_DATE",

         to_char(bj.END_TIME,'mm/dd/yy hh24:mi') "END_DATE",

         bj.output_device_type,

         bj.input_bytes_display "INPUT SIZE",

         bj.output_bytes_display "OUTPUT SIZE",

         bj.time_taken_display

    FROM RC_RMAN_BACKUP_JOB_DETAILS  bj,rc_backup_set_details i

        WHERE bj.session_recid = i.session_recid

   AND bj.start_time > SYSDATE - 27

AND bj.db_name in ('PLT10CR','PLT10DM','PLT11CR','PLT11DM')

AND input_type like '%INCR%'

--ORDER BY NVL (end_time, '01-JAN-1900') DESC

ORDER BY 1,4  DESC

/

but I get lots and lots of the same output.. any ideas what Im missing in my query, like a group by or something? thnx for any help. jd

-------- ---------- -------------------- -------------- -------------- ---------- ------------------------ ------------------------ --------------------

-------- ---------- -------------------- -------------- -------------- ---------- ------------------------ ------------------------ --------------------