declare
tablename varchar(40);
cursor cursor_table_name is
select table_name from user_tables where upper(table_name) like ('%T_TFM%FLOW%') order by table_name;
begin
open cursor_table_name;
loop
fetch cursor_table_name into tablename;
exit when cursor_table_name%notfound;
dbms_output.put_line('delete from '||tablename||' where datetime<to_date(''{0}'',''YYYY-MM-DD HH24:MI:SS'')');
end loop;
close cursor_table_name;
dbms_output.put_line('delete from T_TFM_1M where datetime<to_date(''{0}'',''YYYY-MM-DD HH24:MI:SS'')');
dbms_output.put_line('delete from T_TFM_5M where datetime<to_date(''{0}'',''YYYY-MM-DD HH24:MI:SS'')');
tablename varchar(40);
cursor cursor_table_name is
select table_name from user_tables where upper(table_name) like ('%T_TFM%FLOW%') order by table_name;
begin
open cursor_table_name;
loop
fetch cursor_table_name into tablename;
exit when cursor_table_name%notfound;
dbms_output.put_line('delete from '||tablename||' where datetime<to_date(''{0}'',''YYYY-MM-DD HH24:MI:SS'')');
end loop;
close cursor_table_name;
dbms_output.put_line('delete from T_TFM_1M where datetime<to_date(''{0}'',''YYYY-MM-DD HH24:MI:SS'')');
dbms_output.put_line('delete from T_TFM_5M where datetime<to_date(''{0}'',''YYYY-MM-DD HH24:MI:SS'')');
end;
主要是存一个游标操作模板的例子,以后用起来方便。。。。