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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to include an insert statement on the same table to which the trigger is assigned?

551


How to create a menu in sqlplus or pl/sql?

599


Can a varchar be a primary key?

532


What are inner and outer joins examples of both?

487


Why do we use sql constraints?

645






what are date and time data types in mysql? : Sql dba

487


Is it possible to pass parameters to triggers?

561


What is varchar sql?

602


what is row? : Sql dba

696


What is the maximum number of rows in sql table?

535


What is the difference between explicit and implicit cursors in oracle?

502


differentiate between float and double. : Sql dba

549


Do foreign keys improve performance?

537


Mention what is the use of function "module procedure" in pl/sql?

552


How to pronounce postgresql?

568