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
- 11984 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 can I use instead of union in sql?
Why coalesce is used in sql?
What is sp_helptext?
what is denormalization. : Sql dba
What is a system versioned table?
What is data modelling in sql?
How can I get the number of records affected by a stored procedure?
What is autocommit sql?
What is benefit of creating memory optimized table?
What are the advantages of pl sql?
What are some predefined exceptions in pl/sql?
How can we link a sql database to an existing android app?
Can you rollback after commit?
Can we use views in stored procedure?
Explain what is table in a database?
