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
- 12477 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
What is form and report?
Does sql support programming?
what is a primary key? : Sql dba
What are inner and outer joins examples of both?
How to place comments in pl/sql?
What is a loop in sql?
What is a sql*loader control file?
What is AUTH_ID and AUTH_USER in pl/sql ?
Is nosql faster than sql?
What is a schema sql?
What is rtm in testing?
Mention what does the hierarchical profiler does?
What does count (*) mean?
Is inner join faster than left join?
What is offset in sql query?
