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
- 11980 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 |
How can we implement rollback or commit statement in a trigger?
SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows
how to use regular expression in pattern match conditions? : Sql dba
how do you know if your mysql server is alive? : Sql dba
What is the maximum database size for sql express?
Explain clause in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is the difference between between and in condition operators?
What is the difference between nested table and varray?
What is difference between triggers and stored procedures. And advantages of SP over triggers ?
How long it takes to learn pl sql?
What has stored procedures in sql and how we can use it?
-
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)
