SQL & PL/SQL

Hi,

I am a new Bee and need an advice (STEP BY STEP IN DETAIL) on updating a table...

every week I want to pull log data from a table and save it on another table... something like this

update table log_arch
as
select
* from table log
where
date > Sys_Date - 7

Thanks