摘要： declare --类型定义 strsql string(500); v_ErrorCode NUMBER; -- Variable to hold the error message code v_ErrorText VARCHAR2(200); -- Variable to hold the ... 阅读全文

摘要： declareforInt number(18);seqnum number(18);begin for forInt in 1..20000 loop select seq_forum.nextval into seqnum from dual; insert into frm_answer (... 阅读全文

摘要： declare --类型定义 cursor c_eventstate is Select CampaignId,phonenumber,PolicyNumber from mkt_eventstate a where synstate =0 and packagestate = 2 and err... 阅读全文