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;
工作中自己编写的第一个存储过程.权当留给自己的纪念!