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

Answer Posted / kishore

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does inner join mean?

541


Define union, minus, union all, intersect ?

544


What are the usages of sql?

556


Why do we need a foreign key?

538


how many triggers are allowed in mysql table? : Sql dba

550






Does a join table need a primary key?

519


Explain the purpose of %type and %rowtype data types with the example?

543


How to execute a stored procedure?

550


What is duration in sql profiler trace?

543


Is like operator in sql case sensitive?

500


what is row? : Sql dba

696


How insert into statements in sql?

583


What is a parameter query?

613


Why do we need view in sql?

538


what is the difference between truncate and drop statements? : Sql dba

543