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
- 11916 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 |
Can a foreign key be a duplicate?
Explain ddl statements in pl/sql?
What are user defined stored procedures ?
What is orm in sql?
What is trigger in sql? Explain
What is ttitle and btitle?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
Does sap use sql?
Difference between a query and strored procedure?
What is range partitioning?
What is the difference between sql and mysql?
What are the components of a PL/SQL block ?
-
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)
