create or replace procedure replace(desstr in varchar2,
replacestr in varchar2,
tablename in varchar2,
strgranularity in varchar2,
strorgankey in varchar2,
strstatisticdate in date) is
begin
update t41_systemcal_upday t1
set t1.calchar = replace(t1.calchar, desstr, replacestr)
where t1.itemkey like tablename
and t1.granularity = strgranularity
and t1.statisticdate = strstatisticdate
and t1.organkey = strorgankey;
end replace;
相关文章
- 08-23Oracle存储过程_语法
- 08-23Oracle存储过程语法及编译过程讲解
- 08-23(转)Oracle存储过程基本语法
- 08-23Oracle存储过程基本语法
- 08-23Oracle存储过程常用语法及其使用
- 08-23Oracle存储过程基本语法及基础教程
- 08-23[转]Oracle 存储过程语法
- 08-23Oracle存储过程Procedure语法及案例
- 08-23oracle大数据量更新引发的死锁问题解决方法及oracle分区和存储过程的思考
- 08-23Oracle存储过程及函数