Rectangle Pattern with PL/SQL
To form a rectangular pattern inner loop is iterated for different number of times than the outer loop. Inner loop indicate the number of columns and the outer loop as number of rows in the rectangle.
Rectangle with length as 5 and breadth as 3
*****
*****
*****
C
DECLARE --declare variables numb_row NUMBER; numb_col NUMBER; BEGIN --To get input from user numb_row := &rows; numb_col := &cols; FOR i IN 1..numb_row LOOP FOR j IN 1..numb_col LOOP DBMS_OUTPUT.PUT( '* ' ); END LOOP; DBMS_OUTPUT.NEW_LINE; END LOOP; END; |
Input:
rows:3
columns:5
Rectangle Pattern Output
Conclusion:
Pattern are generated using nested loops .A pattern of any shape can be generated by specifying the number of rows and column along with symmetry . It enhances coding proficiency and enables creative design.
Print Patterns in PL/SQL
You have given a number n then you have to print the number in a right-angled pyramid of *
Examples:
Input : 3
Output :
*
**
***
Input : 7
Output :
*
**
***
****
*****
******
*******
C
DECLARE -- declare variable n, --I AND J of datatype number N NUMBER := 7; I NUMBER; J NUMBER; BEGIN -- loop from 1 to n FOR I IN 1..N LOOP FOR J IN 1..I LOOP DBMS_OUTPUT.PUT( '*' ) ; -- printing * END LOOP; DBMS_OUTPUT.NEW_LINE; -- for new line END LOOP; END; --Program End |
Output:
*
**
***
****
*****
******
*******
A pattern of any shape can be generated by specifying the number of rows and column along with symmetry and regularity. To form a 2D shape one variable is iterated over the other to form the desired pattern.