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 the use of function "module procedure" in pl/sql?
How would you convert date into julian date format?
Why is pl sql used?
what is oracle database ? : Sql dba
how to select unique records from a table? : Sql dba
What is a join query?
Why should I use postgresql?
What are primary key and foreign key and how they work?
What are the benefits of pl/sql packages?
What are sql commands?
What is sql basics?
i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w
4 Answers Scope International,