Skip to content
Related Articles

Related Articles

Floyd’s triangle in PL/SQL

Improve Article
Save Article
  • Difficulty Level : Hard
  • Last Updated : 08 Jun, 2022
Improve Article
Save Article

Prerequisite PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Floyd’s triangle is a right-angled triangular array of natural numbers. It is defined by filling the rows of the triangle with consecutive numbers, starting with a 1 in the top left corner. Given a range of number and the task is to form Floyd’s triangle. 

Examples:

Input: 1-29
Output:
 1
 2 3
 4 5 6
 7 8 9 10
 11 12 13 14 15
 16 17 18 19 20 21
 22 23 24 25 26 27 28

Below is the required implementation: 

SQL




--floyd's triangle in PL/SQL
DECLARE
    --num, var_num variable declare
    --num assign 1
    num     NUMBER := 1;
    var_num VARCHAR2(200);
BEGIN
    --loop  from 1 to 16
    FOR i IN 1..16 LOOP
        FOR j IN 1..i LOOP
            var_num := var_num
                       ||' '
                       ||num;
 
            num := num + 1;
 
            exit WHEN num = 16;
        END LOOP;
 
        --result print
        dbms_output.Put_line(var_num);
 
        exit WHEN num = 16;
 
        var_num := NULL;
    END LOOP;
--end loop
END;
--end program

Output:

 1
 2 3
 4 5 6
 7 8 9 10
 11 12 13 14 15
My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!