Begin
For j in 4403201000 .. 4403202000
Loop
If mod (j, 100) = 0 then
Dbms_output.put_line (j);
End if;
End loop;
End;
what will be the output of this question
Answers were Sorted based on User's Feedback
Answer / kishore
Begin
*
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at line 3
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sanotsh
ERROR at line 1:
ORA-01426: numeric over Flow
ORA-06512: at line 2
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shilpa.oracle
You've probably gone beyond the limit Oracle can cope with
for a number variable.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / leonard
j which is used in for loop is a integer.
integer range is in between -2147483647 to 2147483647.
We can not use integer value in for loop more than
2147483647 which will throw 'ORA-01426: numeric overflow'
exception
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / venkat
this is out put aboue loop
4403201000
4403201100
4403201200
4403201300
4403201400
4403201500
4403201600
4403201700
4403201800
4403201900
4403202000
Is This Answer Correct ? | 0 Yes | 3 No |
What is sql and its types?
What is sql and db2?
explain the difference between delete , truncate and drop commands? : Sql dba
what is the difference between implicit and explicit trigger
What is cross join sql?
package specification-3 procedures package body-2 procedures will is execute
What is normalization sql?
what is switch column,colums cost in oracle?
Is a secondary key the same as a foreign key?
Types of optimization?
Why we use triggers in mysql?
How do you use join?