Monday, April 27, 2009

Query

-- to be used in Sql* plus or some other editor
Set Serverout put on;

DECLARE
MULTIPLICATION_TABLE_FOR NUMBER;
J NUMBER:=0;
L NUMBER;
BEGIN
MULTIPLICATION_TABLE_FOR:=&MULTIPLICATION_TABLE_FOR;
FOR J IN 1..10 LOOP
L:=MULTIPLICATION_TABLE_FOR*J;
DBMS_OUTPUT.PUT_LINE(MULTIPLICATION_TABLE_FOR||'x'||J||'='||L);
END LOOP;
END;

No comments:

Post a Comment