ORACLE 中写一个处理过程.实现把A表中当前小时前的数据插入到B表,要先删除B表中已存的其他数据

delete from b where b表中不需要的数据;
insert into b (filed list) select [filed list] from a where A表中当前小时前的数据 ;
commit ;
打完收工

delete from b;
insert into b (filed list) select [filed list] from a where 当前小时前;

不够具体，只能这样了。