oracle存储过程

create or replace procedure "CDMA"."NON_SMART_OS_LIST_S" is

declare

--声明变量

cursor c_job is select distinct TYPE,OEM from CM_TERMINAL_INFO_PC2  where OS='0';

c_row c_job%rowtype;--定义变量,类型是c_job类型

--执行部分

begin

  delete from NON_SMART_OS_LIST;

  open c_job;

  loop

   fetch c_job into c_row;

   exit when(c_job%notfound);

   if(c_job%found) then insert into NON_SMART_OS_LIST ( TYPE,OEM) values (c_row.TYPE,c_row.OEM);

   end if;

 end loop;

close c_job;

--捕捉异常

EXCEPTION WHEN OTHERS THEN ROLLBACK;

end;

工作中自己编写的第一个存储过程.权当留给自己的纪念！