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;
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;