17,078
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE function sortbyregion_temp
return real
as
v_code integer;
p_number integer := 12;
p_error_info exception;
cursor type1_cur
is
select code from sys_dict where code like '404%' order by name;
BEGIN
------定义游标查找配置记录
open type1_cur;
loop
fetch type1_cur into v_code;
------当查找没有记录时退出
exit when type1_cur%notfound;
update sys_dict set bysort = p_number where code =v_code;
p_number := p_number + 2;
end loop;
close type1_cur;
return 0;
END;