全部博文（101）
发布时间：2012-12-13 11:18:26
analyze.sql sqlplus /nolog << EOF conn center_admin/inxite; set pagesize 5000 set heading off SPOOL ANALYTAB.SQL SELECT 'ANALYZE TABLE CENER_ADMIN.'||TABLE_NAME||' ESTIMATE STATISTICS SAMPLE 20 PER......【阅读全文】
发布时间：2012-12-10 10:41:07
declarerows int :=1000;CURSOR del_cursor IS select id from RPT_REPORTANNEX where originalcode in (select id from rpt_researchreport where pubdate <= date'2011-01-01');TYPE del_table_type is table of RPT_REPORTANNEX.Id%type INDEX BY BINARY_INTEGER;del_table del_table_type ;beginopen del_cursor;loo......【阅读全文】
