The task was to construct partition names from 'P001' to (for some reason) 'P336', as part of a larger maintenance script. Here's what they came up with:
declare p varchar2(4); i number := 1; begin loop if i < 10 then p := 'P00' || to_char(i); elsif i < 100 then p := 'P0' || to_char(i); else p := 'P' || to_char(i); end if; i := i + 1; exit when i > 336; dbms_output.put_line(p); end loop; end;
1 comment:
You expect DBAs to be conversant in using LPAD?
Post a Comment