Patterns in PL / SQL

Generally, the patterns are very interesting to perform. We can make as many shapes as we can in patterns. Let us dive into different types of patterns.

1.) Pattern 1

Pattern Design

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

Pattern Code 1

SQL> DECLARE
    n INTEGER;
    i INTEGER;
    j INTEGER;
  5
    BEGIN
  7
    n:=&n;
    FOR i IN 1..n LOOP
   FOR j IN 1..n LOOP
   dbms_output.put('* ');
   END LOOP;
    DBMS_O UTPUT.NEW_LINE;
   END LOOP;
   END;
   /

Input

Enter value for n: 5
old   8:     n:=&n;
new   8:     n:=5;

Output

* * * * *
* * * * *
* * * * *
* * * * *
* * * * *
PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
    n INTEGER;
    i INTEGER;
    j INTEGER;
  5
    BEGIN
  7
    n:=&n;
    FOR i IN 1..n LOOP
   FOR j IN 1..n LOOP
   dbms_output.put('+ ');
   END LOOP;
    DBMS_OUTPUT.NEW_LINE;
   END LOOP;
   END;
   /

Input

Enter value for n: 7
old   8:     n:=&n;
new   8:     n:=7;

Output

+ + + + + + +
+ + + + + + +
+ + + + + + +
+ + + + + + +
+ + + + + + +
+ + + + + + +
+ + + + + + +

PL/SQL procedure successfully completed.

Pattern Code 3

SQL> DECLARE
    n INTEGER;
    i INTEGER;
    j INTEGER;
  5
    BEGIN
  7
    n:=&n;
    FOR i IN 1..n LOOP
   FOR j IN 1..n LOOP
   dbms_output.put(' '||n);
   END LOOP;
    DBMS_OUTPUT.NEW_LINE;
   END LOOP;
   END;
   /

Input

Enter value for n: 9
old   8:     n:=&n;
new   8:     n:=9;

Output

9 9 9 9 9 9 9 9 9
9 9 9 9 9 9 9 9 9
9 9 9 9 9 9 9 9 9
9 9 9 9 9 9 9 9 9
9 9 9 9 9 9 9 9 9
9 9 9 9 9 9 9 9 9
9 9 9 9 9 9 9 9 9
9 9 9 9 9 9 9 9 9
9 9 9 9 9 9 9 9 9

PL/SQL procedure successfully completed.

2.) Pattern 2

Pattern Design

*
* *
* * *
* * * *

Pattern Code 1

SQL>  DECLARE
    n INTEGER;
    i INTEGER;
    j INTEGER;
  5
    BEGIN
  7
    n:=&n;
    FOR i IN 1..n LOOP
   FOR j IN 1..i LOOP
   dbms_output.put('* ' );
   END LOOP;
    DBMS_OUTPUT.NEW_LINE;
   END LOOP;
   END;
   /

Input

Enter value for n: 5
old   8:     n:=&n;
new   8:     n:=5;

Output

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

PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
    n INTEGER;
    i INTEGER;
    j INTEGER;
  5
    BEGIN
  7
    n:=&n;
    FOR i IN 1..n LOOP
   FOR j IN 1..i LOOP
   dbms_output.put('_ _ ' );
   END LOOP;
    DBMS_OUTPUT.NEW_LINE;
   END LOOP;
   END;
   /

Input

Enter value for n: 7
old   8:     n:=&n;
new   8:     n:=7;

Output

_ _
_ _ _ _
_ _ _ _ _ _
_ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _

PL/SQL procedure successfully completed.

Pattern Code 3

SQL>  DECLARE
    n INTEGER;
    i INTEGER;
    j INTEGER;
  5
    BEGIN
  7
    n:=&n;
    FOR i IN 1..n LOOP
   FOR j IN 1..i LOOP
   dbms_output.put(' '||n );
   END LOOP;
    DBMS_OUTPUT.NEW_LINE;
   END LOOP;
   END;
   /

Input

Enter value for n: 5
old   8:     n:=&n;
new   8:     n:=5;

Output

5
5 5
5 5 5
5 5 5 5
5 5 5 5 5

PL/SQL procedure successfully completed.

3.) Pattern 3

Pattern Design

Pattern Code 1

SQL> DECLARE
     n INTEGER;
        i INTEGER;
        j INTEGER;
  5
        BEGIN
  7
        n:=&n;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(POWER(2,i-1) );
      dbms_output.put(' ');
 13
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 3
old   8:         n:=&n;
new   8:         n:=3;

Output

1
2 2
4 4 4
PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
  5
        BEGIN
  7
        n:=&n;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(POWER(2,i-1) );
      dbms_output.put('     ');
 13
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 5
old   8:         n:=&n;
new   8:         n:=5;

Output

1
2     2
4     4     4
8     8     8     8
16     16     16     16     16

PL/SQL procedure successfully completed.

4.) Pattern 4

Pattern Design

Pattern Code 1

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
  5
        BEGIN
  7
        n:=&n;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(j);
      dbms_output.put(' ');
 13
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 5
old   8:         n:=&n;
new   8:         n:=5;

Output

1
1 2
1 2 3
1 2 3 4
1 2 3 4 5
PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
  5
        BEGIN
  7
        n:=&n;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(j);
      dbms_output.put(' ');
 13
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 10
old   8:         n:=&n;
new   8:         n:=10;

Output

1
1 2
1 2 3
1 2 3 4
1 2 3 4 5
1 2 3 4 5 6
1 2 3 4 5 6 7
1 2 3 4 5 6 7 8
1 2 3 4 5 6 7 8 9
1 2 3 4 5 6 7 8 9 10

PL/SQL procedure successfully completed.

5.) Pattern 5

Pattern Design

Pattern Code 1

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
  5
        BEGIN
  7
        n:=&n;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
       dbms_output.put(i);
      dbms_output.put(' ');
 13
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 5
old   8:         n:=&n;
new   8:         n:=5;

Output

1
2 2
3 3 3
4 4 4 4
5 5 5 5 5

PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
  5
        BEGIN
  7
        n:=&n;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(j);
      dbms_output.put(' ');
 13
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 10
old   8:         n:=&n;
new   8:         n:=10;

Output

1
2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9
10 10 10 10 10 10 10 10 10 10
PL/SQL procedure successfully completed.

6.) Pattern 6

Pattern Design

1
4
9 9
16 16 16
25 25 25 25

Pattern Code 1

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
  5
        BEGIN
  7
        n:=&n;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
       dbms_output.put(i*i);
      dbms_output.put(' ');
 13
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 5
old   8:         n:=&n;
new   8:         n:=5;

Output

1
4 4
9 9 9
16 16 16 16
25 25 25 25 25
PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
  5
        BEGIN
  7
        n:=&n;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(i*i);
      dbms_output.put(' ');
 13
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 10
old   8:         n:=&n;
new   8:         n:=10;

Output

1
4 4
9 9 9
16 16 16 16
25 25 25 25 25
36 36 36 36 36 36
49 49 49 49 49 49 49
64 64 64 64 64 64 64 64
81 81 81 81 81 81 81 81 81
100 100 100 100 100 100 100 100 100 100
PL/SQL procedure successfully completed.

7.) Pattern 7

Pattern Design

Pattern Code 1

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
       k INTEGER;
  6
        BEGIN
  8
        n:=&n;
        k:=0;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(k);
      dbms_output.put(' ');
      k:=k+1;
 16
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 5
old   8:         n:=&n;
new   8:         n:=5;

Output

0
1 2
3 4 5
6 7 8 9
10 11 12 13 14
PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
       k INTEGER;
  6
        BEGIN
  8
        n:=&n;
        k:=0;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(k);
      dbms_output.put(' ');
      k:=k+1;
 16
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 10
old   8:         n:=&n;
new   8:         n:=10;

Output

0
1 2
3 4 5
6 7 8 9
10 11 12 13 14
15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31 32 33 34 35
36 37 38 39 40 41 42 43 44
45 46 47 48 49 50 51 52 53 54
PL/SQL procedure successfully completed.

Pattern Code 3

SQL> DECLARE
        n INTEGER;
        i INTEGER;
       j INTEGER;
       k INTEGER;
  6
        BEGIN
  8
        n:=&n;
        k:=0;
        FOR i IN 1..n LOOP
      FOR j IN 1..i LOOP
      dbms_output.put(k);
      dbms_output.put(' ');
      k:=k+1;
 16
      END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 7
old   8:         n:=&n;
new   8:         n:=7;

Output

0
1 2
3 4 5
6 7 8 9
10 11 12 13 14
15 16 17 18 19 20
21 22 23 24 25 26 27
PL/SQL procedure successfully completed.

7.) Pattern 7

Pattern Design

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

Pattern Code 1

SQL> DECLARE
       n INTEGER;
       i INTEGER;
       j INTEGER;
  5
      BEGIN
  7
       n:=&n;
     FOR i IN 1..n LOOP
     FOR j IN 1..n-i+1 LOOP
     dbms_output.put('* ' );
 12
 13
     END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 5
old   8:        n:=&n;
new   8:        n:=5;

Output

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

PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
       n INTEGER;
       i INTEGER;
       j INTEGER;
  5
      BEGIN
  7
       n:=&n;
     FOR i IN 1..n LOOP
     FOR j IN 1..n-i+1 LOOP
     dbms_output.put('* ' );
 12
 13
     END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 7
old   8:        n:=&n;
new   8:        n:=7;

Output

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

PL/SQL procedure successfully completed.

8.) Pattern 8

Pattern Sample

Pattern Code 1

SQL>    DECLARE
        n INTEGER;
       i INTEGER;
       j INTEGER;
  5
      BEGIN
  7
       n:=&n;
     FOR i IN 1..n LOOP
     FOR j IN 1..n-i+1 LOOP
     dbms_output.put(n-j );
     dbms_output.put(' ');
 13
     END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 5
old   8:        n:=&n;
new   8:        n:=5;

Output

Pattern Code 2

SQL>    DECLARE
        n INTEGER;
       i INTEGER;
       j INTEGER;
  5
      BEGIN
  7
       n:=&n;
     FOR i IN 1..n LOOP
     FOR j IN 1..n-i+1 LOOP
     dbms_output.put(n-j );
     dbms_output.put(' ');
 13
     END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP ;
      END;
      /

Input

Enter value for n: 7
old   8:        n:=&n;
new   8:        n:=7;

Output

6 5 4 3 2 1 0
6 5 4 3 2 1
6 5 4 3 2
6 5 4 3
6 5 4
6 5
6

9.) Pattern 9

Pattern Sample

Pattern Code 1

SQL>  DECLARE
        n INTEGER;
       i INTEGER;
       j INTEGER;
  5
      BEGIN
  7
       n:=&n;
     FOR i IN 1..n LOOP
     FOR j IN 1..n-i+1 LOOP
     dbms_output.put(i+j-1);
     dbms_output.put(' ');
 13
     END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 5
old   8:        n:=&n;
new   8:        n:=5;

Output

1 2 3 4 5
2 3 4 5
3 4 5
4 5
5
PL/SQL procedure successfully completed.

Pattern Code 2

SQL>  DECLARE
        n INTEGER;
       i INTEGER;
       j INTEGER;
  5
      BEGIN
  7
       n:=&n;
     FOR i IN 1..n LOOP
     FOR j IN 1..n-i+1 LOOP
     dbms_output.put(i+j-1);
     dbms_output.put(' ');
 13
     END LOOP;
       DBMS_OUTPUT.NEW_LINE;
      END LOOP;
      END;
      /

Input

Enter value for n: 9
old   8:        n:=&n;
new   8:        n:=9;

Output

1 2 3 4 5 6 7 8 9
2 3 4 5 6 7 8 9
3 4 5 6 7 8 9
4 5 6 7 8 9
5 6 7 8 9
6 7 8 9
7 8 9
8 9
9

PL/SQL procedure successfully completed.

10.) Pattern 10

Pattern Sample

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

Pattern Code 1

SQL> DECLARE
n INTEGER;
i INTEGER:=1;
j INTEGER;
k INTEGER;
BEGIN
n:=&n;
WHILE i<n
loop
j:=1;
WHILE j<n-i
loop
dbms_output.put(' ');
j:=j+2;
end loop;
 16
for k in 1..i
loop
dbms_output.put('* ');
end loop;
dbms_output.new_line;
i:=i+2;
end loop;
 24
i:=7;
while i>=1
loop
j:=9;
while j>i
loop
dbms_output.put(' ');
j:=j-2;
end loop;
 34
for k in 1..i
loop
dbms_output.put('* ');
end loop;
dbms_output.new_line;
i:=i-2;
end loop;
end;
/

Input

Enter value for n: 10
old   7: n:=&n;
new   7: n:=10;

Output

*
* * *
* * * * *
* * * * * * *
* * * * * * * * *
* * * * * * *
* * * * *
* * *
*
PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
n INTEGER;
i INTEGER:=1;
j INTEGER;
k INTEGER;
BEGIN
n:=&n;
WHILE i<n
loop
j:=1;
WHILE j<n-i
loop
dbms_output.put(' ');
j:=j+2;
end loop;
 16
for k in 1..i
loop
dbms_output.put('* ');
end loop;
dbms_output.new_line;
i:=i+2;
end loop;
 24
i:=7;
while i>=1
loop
j:=9;
while j>i
loop
dbms_output.put(' ');
j:=j-2;
end loop;
 34
for k in 1..i
loop
dbms_output.put('* ');
end loop;
dbms_output.new_line;
i:=i-2;
end loop;
end;
/

Input

Enter value for n: 5
old   7: n:=&n;
new   7: n:=5;

Output

*
* * *
* * * * * * *
* * * * *
* * *
*
PL/SQL procedure successfully completed.

11.) Pattern 11

Pattern Sample

1
2 3
2 3 4 5
2 3 4 5 6 7
2 3 4 5 6 7 8 9
2 3 4 5 6 7
2 3 4 5
2 3
1

Pattern Code 1

SQL> DECLARE
n INTEGER;
i INTEGER:=1;
j INTEGER;
k INTEGER;
BEGIN
n:=&n;
WHILE i<n
loop
j:=1;
WHILE j<n-i
loop
dbms_output.put(' ');
j:=j+2;
end loop;
 16
for k in 1..i
loop
dbms_output.put(k);
dbms_output.put(' ');
 21
end loop;
dbms_output.new_line;
i:=i+2;
end loop;
 26
i:=7;
while i>=1
loop
j:=9;
while j>i
loop
dbms_output.put(' ');
j:=j-2;
end loop;
 36
for k in 1..i
loop
dbms_output.put(k);
dbms_output.put(' ');
end loop;
dbms_output.new_line;
i:=i-2;
end loop;
end;
/

Input

Enter value for n: 10
old   7: n:=&n;
new   7: n:=10;

Output

1
1 2 3
1 2 3 4 5
1 2 3 4 5 6 7
1 2 3 4 5 6 7 8 9
1 2 3 4 5 6 7
1 2 3 4 5
1 2 3
1

PL/SQL procedure successfully completed.

Pattern Code 2

SQL> DECLARE
n INTEGER;
i INTEGER:=1;
j INTEGER;
k INTEGER;
BEGIN
n:=&n;
WHILE i<n
loop
j:=1;
WHILE j<n-i
loop
dbms_output.put(' ');
j:=j+2;
end loop;
 16
for k in 1..i
loop
dbms_output.put(k);
dbms_output.put(' ');
 21
end loop;
dbms_output.new_line;
i:=i+2;
end loop;
 26
i:=7;
while i>=1
loop
j:=9;
while j>i
loop
dbms_output.put(' ');
j:=j-2;
end loop;
 36
for k in 1..i
loop
dbms_output.put(k);
dbms_output.put(' ');
end loop;
dbms_output.new_line;
i:=i-2;
end loop;
end;
/

Input

Enter value for n: 13
old   7: n:=&n;
new   7: n:=13;

Output

1
1 2 3
1 2 3 4 5
1 2 3 4 5 6 7
1 2 3 4 5 6 7 8 9
1 2 3 4 5 6 7 8 9 10 11
1 2 3 4 5 6 7
1 2 3 4 5
1 2 3
1
PL/SQL procedure successfully completed.

Next Topic#

← prev next →

Latest Courses

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Python

AI, ML and Data Science

Java

B.Tech and MCA

Web Technology

Software Testing

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

PL/SQL Tutorial

Control Statements

PL/SQL Procedure

PL/SQL Function

PL/SQL Cursor

PL/SQL Exception

PL/SQL Trigger

Misc

Interview Questions

Quiz

Patterns in PL / SQL

1.) Pattern 1

Pattern Design

2.) Pattern 2

Pattern Design

3.) Pattern 3

4.) Pattern 4

Pattern Design

5.) Pattern 5

Pattern Design

6.) Pattern 6

Pattern Design

7.) Pattern 7

Pattern Design

7.) Pattern 7

Pattern Design

8.) Pattern 8

Pattern Sample

9.) Pattern 9

Pattern Sample

10.) Pattern 10

Pattern Sample

11.) Pattern 11

Pattern Sample

Latest Courses

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler