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 'mysqlimport'? : Sql dba
Is left join inner or outer?
What is data abstraction in sql?
What sql database should I use?
How to add new employee details in an employee_details table with the following details
What are the different types of joins in sql?
define sql insert statement ? : Sql dba
What is anonymous block in sql?
How many triggers can be applied to a table?
What is right join in sql?
How do I create an index in word?
How can get second highest salary in sql?
Which is faster union or join?
Are stored procedures compiled?
what is the difference between inner and outer join? Explain with example. : Sql dba