第2个回答 2011-11-25
create or replace procedure PRO_FESTIVALSMS(zzid in varchar2, yhid in varchar2,dxnr varchar2,fszt varchar2) is
lxrid varchar2(32);
lxrsj varchar2(32);
yhzzid varchar2(32);
begin
declare cursor cursor1 is
select lxr.id id,lxr.lxrsj lxrsj,(select t.zzid from AQ_YHXXB t where t.id=yhid) yhzzid
from CRM_LXR lxr
join crm_kh kh on kh.id=lxr.khid
join aq_zz zz on kh.zzid=zz.id
where kh.rowstatus='0'
and lxr.rowstatus='0'
and exists
(select z.id from aq_zz z where kh.zzid=z.id and (z.fzzid=zzid or z.id=zzid));
begin
open cursor1;
loop
fetch cursor1 into lxrid,lxrsj,yhzzid;
exit when cursor1 % NOTFOUND;
insert into
KFDX_DX(id,dxlbid,fsrq,fsfs,fszt,yhid,Dxnr,Sjh,Lxrid,Jlrq,Jlrid,Rowstatus,Dxly,Zzid) values
(sys_guid(),'12000',sysdate,'1',fszt,yhid,dxnr,lxrsj,lxrid,sysdate,yhid,'0','1',yhzzid);
commit;
end loop;
close cursor1;
end;
end PRO_FESTIVALSMS;
第3个回答 2011-11-25
在查询数据集上面的工具栏倒数第二个可以导出表 有cvs,tvs,HTML,XML,sql格式的选择 希望是你要的答案