简单运用动态SQL定JOB整理表碎片SQL

declare 

 sql_1 varchar2(200); 

 sql_2 varchar2(200); 

 begin 

 sql_1:='alter table test enable row movement'; 

 sql_2:='alter table test shrink space'; 

 execute immediate sql_1; 

 execute immediate sql_2; 

 end; 

 /