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
- 12662 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 to escape special characters in sql statements? : Sql dba
Is primary key clustered index?
what is schema? : Sql dba
How do I remove duplicates in two columns?
what is dbms? : Sql dba
what are aggregate and scalar functions? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Is inner join faster than left join?
Does group by remove duplicates?
Do we need to rebuild index after truncate?
What is your daily office routine?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
define sql insert statement ? : Sql dba
What is the current version of postgresql?
What is the current version of sql?
