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

Is sql workbench free?

544


Is sql harder than python?

622


What is pl sql block structure?

555


What are different types of keys?

534


how can you create an empty table from an existing table? : Sql dba

670






What is the unique index?

539


what is the different between now() and current_date()? : Sql dba

536


What is the maximum database size for sql express?

546


Differentiate between syntax and runtime errors.

648


which types of join is used in sql widely? : Sql dba

548


what is blob? : Sql dba

568


How sql query is executed?

571


Can we use delete in merge statement?

521


how to drop an existing index in mysql? : Sql dba

551


how to decrement dates by 1 in mysql? : Sql dba

596