Oracle函数+for循环

create or replace function FilterMinganci(str in varchar) return varchar2 is
  filterWorld varchar2(1000);
  keyCount    int;
begin
  filterWorld := str;
  keyCount    := 0;
  select count(1) into keyCount from dic_keyword;
  for aa in (select keyword from dic_keyword) loop
   select  replace(filterWorld, aa.keyword, ‘*‘) into filterWorld from dual;
    keyCount := keyCount - 1;
    exit when keyCount = 0;
  end loop;
  return(filterWorld);
end;

  

Oracle函数+for循环,布布扣,bubuko.com

Oracle函数+for循环

上一篇:python开发基础(二)运算符以及数据类型之float(浮点类型)


下一篇:MySQLCouldn't find MySQL manager