随笔分类 - sql
摘要:创建存储过程 create procedure WMSendObj(org in varchar2, dept in varchar2) as cursor curss is (select distinct cno from HR_ARC_DISPATCH_OBJ where INCLUDEDOW
阅读全文
摘要:创建存储过程 --创建存储过程 create procedure WMSendObj( --定义参数 @org varchar(40), @dept varchar(40)) as begin --定义游标 declare cu cursor for select cno from hr_arc_d
阅读全文