oracle 动态sql

oracle 动态sql  记录日志，

 

 

Declare

i int:=0;
l_date_b date:=date'2011-11-01';
--l_date_e date:=date'2011-11-30';
l_date_e date:=date'2011-11-01';
l_sys date:=sysdate;
l_str varchar(4000):='';
Begin
while l_date_b<=l_date_e loop

 
       
         
       
  
         l_str:=
               
                   'INSERT  into ct_log   '||
               ' ( numlogguid,  vc2logname,   vc2logcode,   numloglevel,   vc2remark,   datcreatedate )  VALUES '||
                '( SEQ_CT_log.Nextval,''export cdr 20111206 :'||l_sys||''',''export_cdr_20111206'',''INFO'',''liuwen'',sysdate)';
              dbms_output.put_line(l_str);
                 execute immediate l_str;
                   l_date_b:=l_date_b+1;
        commit;
end loop;

End;