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
- 12192 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 you write an index?
what is commit? : Sql dba
Why left join is used in sql?
What is the use of %rowtype?
What is hibernate and its relation to sql?
What is sql rowcount?
Can ddl statements be used in pl/sql?
What are stuff and replace function?
What is the purpose of design view?
Name three sql operations that perform a sort.
Is a foreign key always unique?
Is null operator in sql?
What is the difference between left and left outer join?
How can the performance of a trigger be improved?
Explain what is sql*plus?
