| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
10-16-2007, 05:09 AM
|
|||
|
|||
ANY dialect question:
pl/sql blockWhat will be the result of below PL/SQL block? State the reason for that result.
Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End;     
|
|
10-18-2007, 03:58 PM
|
|||
|
|||
|
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 
|
