Floyd’s triangle in PL/SQL
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
DECLARE
num NUMBER := 1;
var_num VARCHAR2(200);
BEGIN
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;
dbms_output.Put_line(var_num);
exit WHEN num = 16;
var_num := NULL ;
END LOOP;
END ;
|
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
Share your thoughts in the comments
Please Login to comment...