oracle中途结束存储过程？

2014-06-23 02:58:37 2.1k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

单片机按键识别篇---单击---双击----长按　　最近做一任务需要使用一个按键实现三种功能，分别是按键单击功能，按键双击功能和按键长按功能，可能之前没有接触过这类按键复用情况，顶多也只是简单识别单击和长按，没有想过双击以上按键功能，也是绞尽脑汁，想了半天，又上网看了些例程，算是对于按键的识别有点小小的了解，感觉这个功能挺实用，在此做个随笔。一、思路　　1.识别长按操作思路：我们使用系统定时器定时，然后让系统每过一段时间去扫描按键I/O... 阅读详情

oracle 存储过程 if.....else...
因为有好几个 if.....else... 怎么在else中中途结束存储过程？
return？？

...全文

【项目立项管理、项目整合管理】30天通过软考高项-第二天 ①项目或阶段的概述；②范围目标、范围的评估标准，证明达到完⼯标准的证据；③质量目标、项目和产品质量的评估标准、相关核实信息和实际里程碑交付日期以及偏差原因；④成本目标，包括可接受的成本区间、实际成本，产⽣任何偏差的原因等；⑤最终产品、服务或成果的确认信息的总结；⑥进度计划目标，包括成果是否实现项目预期效益：如果在项目结束时未能实现效益，则指出效益实现程度并预计未来实现情况；阅读详情

天空之城B哥

Oracle 17,133 成员 55,258 内容

+ 关注 + 加入社区

切换为时间正序

天空之城B哥 2014-06-23

打赏
举报

请教亚～～～～～

天空之城B哥 2014-06-23

打赏
举报

create or replace package body material_mgmt is procedure modify_material_category_name(categoryId number) is parentCategoryName varchar2(256); parentId number(19); cateName varchar2(64); categoryName varchar2(256); i number(19); begin select t.parentid into parentId from t_materialcategory t where t.id = categoryId; select t.name into cateName from t_materialcategory t where t.id = categoryId; if parentId is null then update t_materialcategory t set t.categoryname = cateName where t.id = categoryId; else select t.categoryname into parentCategoryName from t_materialcategory t where t.id = parentId; categoryName := parentCategoryName ||'-'|| cateName; update t_materialcategory t set t.categoryname = categoryName where t.id = categoryId; end if; select count(*) into i from t_materialCategory o where o.parentid = categoryId; if i > 0 then update t_materialcategory t set t.categoryname = ( select p.categoryname ||'-'|| t.name from t_materialcategory p where p.id = t.parentid ) where t.id in (select o.id from t_materialCategory o where o.parentid = categoryId ); else return; end if; select count(*) into i from t_materialCategory o where o.parentid in(select o.id from t_materialCategory o where o.parentid = categoryId and o.leaf = 0 ); if i > 0 then update t_materialcategory t set t.categoryname = ( select p.categoryname ||'-'|| t.name from t_materialcategory p where p.id = t.parentid ) where t.parentid in (select o.id from t_materialCategory o where o.parentid = categoryId and o.leaf = 0); else return; end if; select count(*) into i from t_materialCategory o where o.parentid in(select o.id from t_materialCategory o where o.parentid in(select o.id from t_materialCategory o where o.parentid = categoryId and o.leaf = 0)and o.leaf = 0); if i > 0 then update t_materialcategory t set t.categoryname = ( select p.categoryname ||'-'|| t.name from t_materialcategory p where p.id = t.parentid ) where t.parentid in (select o.id from t_materialCategory o where o.parentid in(select o.id from t_materialCategory o where o.parentid = categoryId and o.leaf = 0)and o.leaf = 0); else return; end if; select count(*) into i from t_materialCategory o where o.parentid in(select o.id from t_materialCategory o where o.parentid in(select o.id from t_materialCategory o where o.parentid in(select o.id from t_materialCategory o where o.parentid = categoryId and o.leaf = 0)and o.leaf = 0)and o.leaf = 0); if i > 0 then update t_materialcategory t set t.categoryname = ( select p.categoryname ||'-'|| t.name from t_materialcategory p where p.id = t.parentid ) where t.parentid in (select o.id from t_materialCategory o where o.parentid in(select o.id from t_materialCategory o where o.parentid in (select o.id from t_materialCategory o where o.parentid = categoryId and o.leaf = 0)and o.leaf = 0) and o.leaf = 0); else return; end if; commit; end; end material_mgmt; 整个过程代码，，在每个else里加return了。出现的问题是我最上面的if 。。else else语句不执行亚？

天空之城B哥 2014-06-23

打赏
举报

一颗向往数据的心丶 2014-06-23

打赏
举报

return;

liao_z_j 2014-06-23

打赏
举报

DECLARE A NUMBER(6); BEGIN IF 1 = 2 THEN A := 1; ELSIF 2 = 2 THEN A := 2; DBMS_OUTPUT.PUT_LINE(A); RETURN; ELSE A := 3; DBMS_OUTPUT.PUT_LINE(A); END IF; END; 是的。

oracle中途结束存储过程？

相关推荐