Oracle定时清空半年前表数据（表结构相同，一天一张GPS数据表）

思路:

1、查询出半年前表

            select table_name from user_tables where table_name in (

            select TABLE_NAME from (

            select u.TABLE_NAME from user_tables u,

            (select add_months(sysdate,-6) half_year from dual) a

            where u.LAST_ANALYZED<=half_year

            order by u.LAST_ANALYZED)) and table_name like '%筛选表名%';

2、创建存储过程

create or replace procedure delete_gps

AS