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 |
Why plvtab is considered as the easiest way to access the pl/sql table?
Is it possible for a table to have more than one foreign key?
Is sqlite free?
What is schema in sql example?
What is exception? What are the types of exceptions?
what the meaning of sql
How to run sql functions in pl/sql?
Can you create a table with Primary Key not as the clustered index.
Does asenumerable execute the query?
What is where clause in sql?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Can we rollback truncate?