declare
cursor cc is select distinct substr(vc_mobileno,1,3) trd from dw_foxuser_det order by 1;
rec_ind number;
ccrec cc%rowtype;
begin
 select count(*) into rec_ind from user_table where table_name = upper('tp_20120807_a01');
 if (rec_ind <> 0) then
Execute immediate 'drop table tp_20120807_a01 purge';
Execute immediate 'create table tp_20120807_a01 (test varchar2(11))';
end if;
 for ccrec in cc loop
-- 下面这一句,如果使用动态语句...
 insert into tp_20120807_a01 select vc_mobileno from dw_foxuser_det where substr(vc_mobileno,4,3) = ccrec.trd;
commit;
end loop;
End;

Execute immeidiate 'insert into tp_20120807_a01 select vc_mobileno from dw_foxuser_det where substr(vc_mobileno,4,3) = ccrec.trd';

--你的ccrec.trd是外面的值
Execute immeidiate 'insert into tp_20120807_a01 select vc_mobileno from dw_foxuser_det where substr(vc_mobileno,4,3) = '||ccrec.trd;