e.g. Addition of odd numbers.
DECLARE
total BINARY_INTEGER := 0;
BEGIN
FOR i in 1..10 LOOP
IF MOD(i/2) = 0 THEN
CONTINUE;
END IF;
SUM = SUM + i;
END LOOP,
DBMS_OUTPUT.PUT_LINE('Sum of odd numbers is '|| sum );
END;
/
DECLARE
total BINARY_INTEGER := 0;
BEGIN
FOR i in 1..10 LOOP
IF MOD(i/2) = 0 THEN
CONTINUE;
END IF;
SUM = SUM + i;
END LOOP,
DBMS_OUTPUT.PUT_LINE('Sum of odd numbers is '|| sum );
END;
/
Oracle External Table External tables are defined as tables that do not resides in the database allows you to access data that is stor...
No comments:
Post a Comment