Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / kvijay6aa

Answers were Sorted based on User's Feedback



Begin For j in 4403201000 .. 4403202000 Loop ..

Answer / nitesh

ORA-01426 : Numeric overflow

Is This Answer Correct ?    8 Yes 0 No

Begin For j in 4403201000 .. 4403202000 Loop ..

Answer / kishore

Begin
*
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at line 3

Is This Answer Correct ?    3 Yes 0 No

Begin For j in 4403201000 .. 4403202000 Loop ..

Answer / sanotsh

ERROR at line 1:
ORA-01426: numeric over Flow
ORA-06512: at line 2

Is This Answer Correct ?    3 Yes 0 No

Begin For j in 4403201000 .. 4403202000 Loop ..

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

Begin For j in 4403201000 .. 4403202000 Loop ..

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

Begin For j in 4403201000 .. 4403202000 Loop ..

Answer / iamanocp

It displays 4403201000 to 4403202000

Is This Answer Correct ?    0 Yes 1 No

Begin For j in 4403201000 .. 4403202000 Loop ..

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

Post New Answer

More SQL PLSQL Interview Questions

How can a function retun more than one value in oracle with proper example?

0 Answers  

What are views in sql?

0 Answers  

Can we use commit inside a trigger?

0 Answers  

what is 'mysqlshow'? : Sql dba

0 Answers  

what is a cursor

9 Answers   IBM, TCS, Wipro,




How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

what the meaning of sql

8 Answers  

What are user defined stored procedures ?

3 Answers   BirlaSoft,

What is the difference between clustered and non-clustered index in sql?

0 Answers  

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

What happens when a trigger is associated to a view?

0 Answers  

what is meant by tuning and tk proof?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories