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
- 10957 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 many commands are there in sql?
What is a sql*loader control file?
What does pl sql stand for?
What is scalar and vector?
What is pl sql code?
What are the different sql languages?
What is type and rowtype in pl sql?
What does partition by mean in sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is the difference between nested table and varray?
Write a query to find the names of users that begin with "um" in sql?
what does it mean to have quoted_identifier on? : Sql dba
define sql update statement ? : Sql dba
Which command is used to delete a package?
What is sql trigger example?
