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
- 12264 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishore
Begin
*
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at line 3
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sanotsh
ERROR at line 1:
ORA-01426: numeric over Flow
ORA-06512: at line 2
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shilpa.oracle
You've probably gone beyond the limit Oracle can cope with
for a number variable.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / venkat
this is out put aboue loop
4403201000
4403201100
4403201200
4403201300
4403201400
4403201500
4403201600
4403201700
4403201800
4403201900
4403202000
| Is This Answer Correct ? | 0 Yes | 3 No |
Why do we use sqlite?
What is scalar function?
Is null operator in sql?
What are the methods of filing?
explain about mysql and its features. : Sql dba
How do I find sql profiler?
What is sql profiling in oracle?
What is use of package in pl sql?
How do you declare a user-defined exception?
How do I clear the screen in sql plus?
What are types of joins?
What do you understand by pl/sql records?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
