Thread: pl/sql block
View Single Post
  #2 (permalink)  
Old 10-18-2007, 03:58 PM
Unregistered
 
Posts: n/a
Default 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
Reply With Quote