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
Answer Posted / 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 |
Post New Answer View All Answers
What is recursive stored procedure?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is meant by cursor in sql?
What is oracle sql called?
What is a dynamic query?
How to run sql*plus commands in sql developer?
What are the different ddl commands in sql?
Is sql the best database?
What is row_number () in sql?
What is bitemporal narrowing?
What is a left inner join?
What are the different sql commands?
Where do we use pl sql?
What is the difference between partitioning and sharding?
What is dense_rank?