GFG App
Open App
Browser
Continue

# 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

 `--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