My Codding Doubt

Wednesday, 9 March 2016

Implementation of multiplication table in oracle pl-sql

Implementation of multiplication table 17 in oracle pl-sql (while loop)

DECLARE
a number(4) := 1;
c number(4);
b number(4) := 17;
BEGIN
dbms_output.put_line('Multiplication table for 2 table is (implemented using while loop):');
WHILE a < 11 LOOP
c := b*a;
dbms_output.put_line( b || ' * ' || a || ' = ' || c );
a := a + 1;
END LOOP;
END;