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

Rail Fence Cipher Program in C and C++[Encryption & Decryption]

Here you will get rail fence cipher program in C and C++ for encryption and decryption. It is a kind of transposition cipher which is also known as zigzag cipher. Below is an example. Here Key = 3. For encryption we write the message diagonally in zigzag form in a matrix having total rows = key and total columns = message length. Then read the matrix row wise horizontally to get encrypted message. Rail Fence Cipher Program in C #include<stdio.h> #include<string.h> void encryptMsg(char msg[], int key){ int msgLen = strlen(msg), i, j, k = -1, row = 0, col = 0; char railMatrix[key][msgLen]; for(i = 0; i < key; ++i) for(j = 0; j < msgLen; ++j) railMatrix[i][j] = '\n'; for(i = 0; i < msgLen; ++i){ railMatrix[row][col++] = msg[i]; if(row == 0 || row == key-1) k= k * (-1); row = row + k; } printf("\nEncrypted Message: "); for(i = 0; i < key; ++i) f...
3 comments
Read more

Data Encryption Standard (DES) Algorithm

Data Encryption Standard is a symmetric-key algorithm for the encrypting the data. It comes under block cipher algorithm which follows Feistel structure. Here is the block diagram of Data Encryption Standard. Fig1: DES Algorithm Block Diagram [Image Source: Cryptography and Network Security Principles and Practices 4 th Ed by William Stallings] Explanation for above diagram: Each character of plain text converted into binary format. Every time we take 64 bits from that and give as input to DES algorithm, then it processed through 16 rounds and then converted to cipher text. Initial Permutation: 64 bit plain text goes under initial permutation and then given to round 1. Since initial permutation step receiving 64 bits, it contains an 1×64 matrix which contains numbers from 1 to 64 but in shuffled order. After that, we arrange our original 64 bit text in the order mentioned in that matrix. [You can see the matrix in below code] After initial permutation, 64 bit text passed throug...
Post a Comment
Read more

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