truncate table output
/
-------------------------------------------------------------------------------
-- Examples of a nested FOR loop
-- this example creates a multiplication table of any size (default 10)
-------------------------------------------------------------------------------
DECLARE
    max_hour    integer := 23; 
    max_minute  integer := 59; 
    line        varchar2(500);

BEGIN
    FOR v_hour IN 0 .. max_hour LOOP                -- loop through the hours
        line := 'The hour is ' || v_hour || ' - ';
                                                    -- nested loop
        FOR v_minute IN 0..max_minute LOOP          -- loop through the minutes 
            line :=  line || v_minute || ','; 
        END LOOP;

        insert into output values(line);
    END LOOP;
END;
/

select * from output