Print a star patterns in PL/SQL programming

PL/SQL is one of three key programming languages which is only available with the Oracle Database. PL/SQL is an relational database.

Copy the below PL/SQL program and execute it. In this program, we are going to share how to reverse a number in PL/SQL with the output.

declare

-- declare variable n,

i and j-- of datatype number

n number :

= 7;

i number;

j number;

begin

for i in 1..n

loop

for j in 1..i

loop

dbms_output.put('*');

end loop;

dbms_output.new_line;

end loop;

end;

*
**
***
****
*****
******
*******

Editorial Staff

Editorial Staff at FreeWebMentor is a team of professional developers leads by Prem Tiwari