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 / sanotsh

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is query execution plan in sql?

556


Is primary key clustered index?

510


what is the difference between $message and $$message? : Sql dba

540


How do I tune a sql query?

501


What is the difference between in and between in sql?

565






Is ms sql is free?

522


Can we create clustered index without primary key?

517


what is query cache in mysql? : Sql dba

567


Which operator is used in query for pattern matching?

615


Explain the update statement in sql

552


What is normalisation in sql?

538


what is the use of double ampersand (&&) in sql queries?

616


What is delete command in sql?

545


What does inner join mean?

542


What is the maximum rows in csv?

479