sql -生成清库脚本
利用游标cursor
declare cursor c_sor is select table_name from user_tables where table_name like upper('pms%'); begin for c in c_sor loop dbms_output.put_line('delete from '|| c.table_name); dbms_output.put_line(' call proc_correct_tableandseq( Q'|| c.table_name || ' Q, QidQ, Qseq_' || c.table_name || ' Q)'); end loop; end