Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 11920 Views
- TCS, I also Faced
- E-Mail Answers
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
How do I find duplicates in a single column in sql?
what is a constraint? Tell me about its various levels. : Sql dba
What are the set operators in sql?
How to avoid using cursors?
what are tables and fields? : Sql dba
how many ways we can we find the current date using mysql? : Sql dba
What is sqlca in db2?
How do I run a pl sql program?
what are all the different types of indexes? : Sql dba
What are the advantages of pl sql?
What is before and after trigger?
Is join and inner join the same?
What is t-sql? : Transact sql
What is a clob in sql?
What does := mean in pl sql?
