17,377
社区成员
发帖
与我相关
我的任务
分享
declare
str varchar2(100);
begin
for i in (select table_name from user_tables where instr(table_name,'DATA_ERR',1)>0)
loop
str:='truncate table '||i.table_name;
execute immediate str;
end loop;
end;
CREATE OR REPLACE PROCEDURE "MAIN" (max_frag int) is
begin
declare
i_num int;
i_len int;
s_num varchar(20);
begin
i_num :=0;
i_len :=length(i_num);
LOOP
EXIT WHEN i_num>max_frag;
s_num :=LPAD(i_num,i_len,0);
---create_analysis_cdr_origin (s_num);
main_preprocess(s_num);
main_check;
execute immediate 'insert into analysis_cdr_session_all select * from analysis_cdr_session';
dbms_output.put_line(s_num||'+'||i_len);
execute immediate 'commit';
--main_analysis;
--main_report;
i_num := i_num +1 ;
end loop;
create_diff_date_session;
execute immediate 'commit';
create_analysis_cdr_ppp;
execute immediate 'commit';
-- dbms_output.put_line('do create_analysis_cdr_user');
create_analysis_cdr_user;
execute immediate 'commit';
main_check;
execute immediate 'commit';
check_repeat_cdr;
execute immediate 'commit';
end;
end main;
/