square.sql

CREATE TABLE SQUARE(num NUMBER PRIMARY KEY);
CREATE TABLE CUBE(num NUMBER PRIMARY KEY);

SET SERVEROUTPUT ON;
SET VERIFY OFF;

DECLARE 
    num NUMBER;
BEGIN
    num := &user_input;
    FOR i IN 1..num LOOP
    
        IF (i * i <= num) THEN
            BEGIN
                INSERT INTO SQUARE VALUES(i * i);
            EXCEPTION
                WHEN DUP_VAL_ON_INDEX THEN
                    NULL;  
            END;
        END IF;

        IF (i * i * i <= num) THEN
            BEGIN
                INSERT INTO CUBE VALUES(i * i * i);
            EXCEPTION
                WHEN DUP_VAL_ON_INDEX THEN
                    NULL;  
            END;
        END IF;
    END LOOP;

    
    DBMS_OUTPUT.PUT_LINE('PERFECT SQUARE:');
    FOR rec IN (SELECT * FROM SQUARE ORDER BY num) LOOP
        DBMS_OUTPUT.PUT_LINE(rec.num);
    END LOOP;

    
    DBMS_OUTPUT.PUT_LINE('PERFECT CUBE:');
    FOR rec IN (SELECT * FROM CUBE ORDER BY num) LOOP
        DBMS_OUTPUT.PUT_LINE(rec.num);
    END LOOP;

END;
/

DROP TABLE SQUARE;
DROP TABLE CUBE;