column name format a80
alter session set nls_date_format='ddmmyyyy hh24:mi:ss';

select * from
(select thread#,dest_id,SEQUENCE#,completion_time,name from V$ARCHIVED_LOG where thread# = &1 and dest_id = &2 order by SEQUENCE# desc)
where rownum < &3;