You Asked

I've three questions

1) Suppose I have a collection of numbers say 300 values & i want to initialise with number 72
what would be the best way to do so ,rather than writing 300 times

2) I've to generate reports in pdf so what would you suggest any open source library for generating pdf or to use oracle reports

3) which utility should we use for logging and profiling

and Connor said...

1) example for nested table and associative array below

SQL> declare
  2    type t1 is table of int index by pls_integer;
  3    type t2 is table of int;
  4
  5    v1 t1;
  6    v2 t2;
  7  begin
  8    for i in 1 .. 300 loop
  9      v1(i) := 72;
 10    end loop;
 11
 12    v2 := t2();
 13    v2.extend(300);
 14    for i in 1 .. 300 loop
 15      v2(i) := 72;
 16    end loop;
 17  end;
 18  /

PL/SQL procedure successfully completed.