declarev_table_namevarchar(255):='';cursorcur_tbisselecttable_namefromuser_tableswheretable_nameNOTlike'Z_%'ANDtable_nameNOTlike'TMP_%';beginopencur_tb;fetchcur_tbintov_table_name;loopifcur_tb%foundthenbeginexecuteimmediate'analyzetable'||v_table_name||'computestatistics';exceptionwhenothersthendbms_output.put_line('分析表异常：'||sqlerrm);end;fetchcur_tbintov_table_name;elseexit;endif;endloop;closecur_tb;end;
