1.

How To Use "while" Statements?

Answer»

If you have a block of codes to be executed repeatedly based a condition, you can use the "WHILE ... LOOP" statement. Here is a SAMPLE script on WHILE STATEMENTS:

DECLARE TOTAL NUMBER; BEGIN total := 0; WHILE total < 10 LOOP total := total+1; END LOOP; DBMS_OUTPUT.PUT_LINE('Total counts: ' || TO_CHAR(total)); END;

This script should print this: Total counts: 10

If you have a block of codes to be executed repeatedly based a condition, you can use the "WHILE ... LOOP" statement. Here is a sample script on WHILE statements:

This script should print this: Total counts: 10


Discussion

No Comment Found

Related InterviewSolutions