do bulk insert in oracle - example

insert into appointments_backup (select * from appointments s
where s.TXN_DATE between to_date('01/01/2008','dd/mm/yyyy')
and to_date('01/06/2008','dd/mm/yyyy')
)