ANY answer.
Re: pl/sql block
The code as it is gives a numeric over flow error.t
ithink you know the range of a number in pl/sql;
but if the same code is give like this gives----------------
Begin
For j in 3201000 .. 3202000
Loop
If mod (j, 100) = 0 then
Dbms_output.put_line (j);
End if;
End loop;
End;
will give the following out put
3201000
3201100
3201200
----------
goes on
and last u will get
3202000
|