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.

Print a star patterns in PL/SQL programming

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;

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;

Output

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

If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.

Print a star patterns in PL/SQL programming

Print a star patterns in PL/SQL programming

Output

Recommended Posts:

webmentor