oracle函数的demo

create or replace function transformPartition(minS in number,
                                              maxS in number)
  return varchar2 is
  Result varchar2(5000);
  minNum number;
  maxNum number;
begin
  select trunc(minS / 300001, 0) + 1 into minNum from dual;
  select trunc(maxS / 300001, 0) + 1 into maxNum from dual;


  while minNum <= maxNum loop
    Result := Result || 'PART_' || minNum || '/';
    minNum := minNum + 1;
  end loop;
  return(Result);
end transformPartition;