Skip to main content

PL/SQL Program to Print Patterns

Here you will get plsql programs to print patterns of stars, numbers and alphabets.

Pattern 1:

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

declare
        n number:=5;
        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;
/

Pattern 2:

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

declare
        n number:=5;
        i number;
        j number;
begin
        for i in reverse 1..n
        loop
                for j in 1..i
                loop
                        dbms_output.put('*');
                end loop;
                
                dbms_output.new_line;
        end loop;
end;
/

Pattern 3:

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

declare
        n number:=5;
        i number;
        j number;
        k number;
begin
        for i in 1..n
        loop
                for j in 1..n-i
                loop
                        dbms_output.put(' ');
                end loop;

                for k in 1..i
                loop
                        dbms_output.put('*');
                end loop;
                
                dbms_output.new_line;
        end loop;
end;
/

Pattern 4:

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

declare
        n number:=5;
        i number;
        j number;
        k number;
begin
        for i in reverse 1..n
        loop
                for j in 1..n-i
                loop
                        dbms_output.put(' ');
                end loop;

                for k in 1..i
                loop
                        dbms_output.put('*');
                end loop;
                
                dbms_output.new_line;
        end loop;
end;
/

Pattern 5:

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

declare
        n number:=10;
        i number:=1;
        j number;
        k number;
begin
        while i<n
        loop
                j:=1;
                while j<n-i
                loop
                        dbms_output.put(' ');
                        j:=j+2;
                end loop;

                for k in 1..i
                loop
                        dbms_output.put('*');
                end loop;
                
                dbms_output.new_line;
                i:=i+2;
        end loop;
end;
/

Pattern 6:

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

declare
        i number:=9;
        j number;
        k number;
begin
        while i>=1
        loop
                j:=9;
                while j>i
                loop
                        dbms_output.put(' ');
                        j:=j-2;
                end loop;

                for k in 1..i
                loop
                        dbms_output.put('*');
                end loop;
                
                dbms_output.new_line;
                i:=i-2;
        end loop;
end;
/

Pattern 7:

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

declare
        n number:=10;
        i number:=1;
        j number;
        k number;
begin
        while i<n
        loop
                j:=1;
                while j<n-i
                loop
                        dbms_output.put(' ');
                        j:=j+2;
                end loop;

                for k in 1..i
                loop
                        dbms_output.put('*');
                end loop;
                
                dbms_output.new_line;
                i:=i+2;
        end loop;

        i:=7;
        
        while i>=1
        loop
                j:=9;
                while j>i
                loop
                        dbms_output.put(' ');
                        j:=j-2;
                end loop;

                for k in 1..i
                loop
                        dbms_output.put('*');
                end loop;
                
                dbms_output.new_line;
                i:=i-2;
        end loop;       
end;
/

Comment below if you need any other pattern. I will try to add it here.

The post PL/SQL Program to Print Patterns appeared first on The Crazy Programmer.



from The Crazy Programmer https://www.thecrazyprogrammer.com/2017/10/plsql-program-print-patterns.html
Labels:

Comments

Post a Comment

Popular posts from this blog

dotnet sdk list and dotnet sdk latest

Can someone make .NET Core better with a simple global command? Fanie Reynders did and he did it in a simple and elegant way. I'm envious, in fact, because I spec'ed this exact thing out in a meeting a few months ago but I could have just done it like he did and I would have used fewer keystrokes! Last year when .NET Core was just getting started, there was a "DNVM" helper command that you could use to simplify dealing with multiple versions of the .NET SDK on one machine. Later, rather than 'switching global SDK versions,' switching was simplified to be handled on a folder by folder basis. That meant that if you had a project in a folder with no global.json that pinned the SDK version, your project would use the latest installed version. If you liked, you could create a global.json file and pin your project's folder to a specific version. Great, but I would constantly have to google to remember the format for the global.json file, and I'd constan...
Post a Comment
Read more

15 Web Design Trends to Watch in 2018

The modern world is full of extraordinary things that influence our imagination and mood. Our soul needs a perfect atmosphere and impressive spots. To apply such things in practice, we have submitted the list of the web trends that deserve your attention. Robert frost design analysis will meet all your wishes and expectations. Image Source Web Design Trends to Watch in 2018 1. More Organic Shapes Until this year, web design, as well as mobile design, were based on the right-angled and sharp-edged shapes. However, it seems that this year will bring some significant changes in the field of web design. The recent trends will offer the absolute rounded corners. In addition, the web design of 2018 will make the real things look like the cartoonish ones. 2.   Bold Minimalism Although some of you may think that this web design trend will not attract the Internet users. Indeed, the notion of minimalism is often associated with boredom and dullness. However, in this case, bold ...
Post a Comment
Read more

R vs Python for Machine Learning

There are so many things to learn before to choose which language is good for Machine Learning. We will discuss each and everything about R as well as Python and the situation or problem in which situation we have to use which language. Let’s start Python and R are the two most Commonly used Programming Languages for Machine Learning and because of the popularity of both the languages Novice or you can say fresher are getting confused, whether they should choose R or Python language to commence their career in the Machine learning domain. Don’t worry guys through this article we will discuss R vs Python for Machine Learning. So, without exaggerating this article let’s get started. We will start it from the very Basics things or definitions. R vs Python for Machine Learning Introduction R is a programming language made by statisticians and data miners for statistical analysis and graphics supported by R foundation for statistical computing. R also provides high-quality graphics and...
1 comment
Read more