摘要: create or replace procedure data_move(param in number) iscursor enterprise is select SENTERPRISEID, SSPECIALNUMBER, NSPECIALNUMBERTYPE FROM e_uc_specialcode;enter char(10);spnumber VARCHAR2(32);sptype number;id number;beginopen enterprise;id:=1;loop fetch enterprise into enter, spnumber, sptype; ex. 阅读全文
posted @ 2013-07-27 21:37 holycrap 阅读(371) 评论(0) 推荐(0) 编辑