Open In App

Floyd’s triangle in PL/SQL

Improve
Improve
Like Article
Like
Save
Share
Report

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

Last Updated : 08 Jun, 2022
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads