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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n LOOP
11 dbms_output.put('* ');
12 END LOOP;
13 DBMS_O UTPUT.NEW_LINE;
14 END LOOP;
15 END;
16 / 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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n LOOP
11 dbms_output.put('+ ');
12 END LOOP;
13 DBMS_OUTPUT.NEW_LINE;
14 END LOOP;
15 END;
16 / 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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n LOOP
11 dbms_output.put(' '||n);
12 END LOOP;
13 DBMS_OUTPUT.NEW_LINE;
14 END LOOP;
15 END;
16 / 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
*
* *
* * *
* * * * SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put('* ' );
12 END LOOP;
13 DBMS_OUTPUT.NEW_LINE;
14 END LOOP;
15 END;
16 /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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put('_ _ ' );
12 END LOOP;
13 DBMS_OUTPUT.NEW_LINE;
14 END LOOP;
15 END;
16 / 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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(' '||n );
12 END LOOP;
13 DBMS_OUTPUT.NEW_LINE;
14 END LOOP;
15 END;
16 / 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
1
2 2
4 4 4
8 8 8 8 Pattern Code 1
SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(POWER(2,i-1) );
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 /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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(POWER(2,i-1) );
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 /Enter value for n: 5
old 8: n:=&n;
new 8: n:=5;Output
PL/SQL procedure successfully completed.
4.) Pattern 4
Pattern Design
1
2 2
4 4 4
8 8 8 8
16 16 16 16 161
1 2
1 2 3
1 2 3 4
1 2 3 4 5Pattern Code 1
SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(j);
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 /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.
SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(j);
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 /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
1
2 2
3 3 3
4 4 4 4
5 5 5 5 5 Pattern Code 1
SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(i);
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 / 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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(j);
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 / 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 4
9 9 9
16 16 16 16
25 25 25 25 25 Pattern Code 1
SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(i*i);
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 /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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..i LOOP
11 dbms_output.put(i*i);
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 / 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
0
1 2
3 4 5
6 7 8 9 SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5 k INTEGER;
6
7 BEGIN
8
9 n:=&n;
10 k:=0;
11 FOR i IN 1..n LOOP
12 FOR j IN 1..i LOOP
13 dbms_output.put(k);
14 dbms_output.put(' ');
15 k:=k+1;
16
17 END LOOP;
18 DBMS_OUTPUT.NEW_LINE;
19 END LOOP;
20 END;
21 /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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5 k INTEGER;
6
7 BEGIN
8
9 n:=&n;
10 k:=0;
11 FOR i IN 1..n LOOP
12 FOR j IN 1..i LOOP
13 dbms_output.put(k);
14 dbms_output.put(' ');
15 k:=k+1;
16
17 END LOOP;
18 DBMS_OUTPUT.NEW_LINE;
19 END LOOP;
20 END;
21 / 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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5 k INTEGER;
6
7 BEGIN
8
9 n:=&n;
10 k:=0;
11 FOR i IN 1..n LOOP
12 FOR j IN 1..i LOOP
13 dbms_output.put(k);
14 dbms_output.put(' ');
15 k:=k+1;
16
17 END LOOP;
18 DBMS_OUTPUT.NEW_LINE;
19 END LOOP;
20 END;
21 /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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n-i+1 LOOP
11 dbms_output.put('* ' );
12
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 / 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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n-i+1 LOOP
11 dbms_output.put('* ' );
12
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 /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
4 3 2 1 0
4 3 2 1
4 3 2
4 3
4Pattern Code 1
SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n-i+1 LOOP
11 dbms_output.put(n-j );
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 / Input
Enter value for n: 5
old 8: n:=&n;
new 8: n:=5; Output
4 3 2 1 0
4 3 2 1
4 3 2
4 3
4
Pattern Code 2
SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n-i+1 LOOP
11 dbms_output.put(n-j );
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP ;
17 END;
18 / 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
1 2 3 4 5
2 3 4 5
3 4 5
4 5
5SQL> DECLARE
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n-i+1 LOOP
11 dbms_output.put(i+j-1);
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 /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
2 n INTEGER;
3 i INTEGER;
4 j INTEGER;
5
6 BEGIN
7
8 n:=&n;
9 FOR i IN 1..n LOOP
10 FOR j IN 1..n-i+1 LOOP
11 dbms_output.put(i+j-1);
12 dbms_output.put(' ');
13
14 END LOOP;
15 DBMS_OUTPUT.NEW_LINE;
16 END LOOP;
17 END;
18 / 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
*
* * *
* * * * *
* * * * * * *
* * * * * * * * *
* * * * * * *
* * * * *
* * *
* SQL> DECLARE
2 n INTEGER;
3 i INTEGER:=1;
4 j INTEGER;
5 k INTEGER;
6 BEGIN
7 n:=&n;
8 WHILE i<n
9 loop
10 j:=1;
11 WHILE j<n-i
12 loop
13 dbms_output.put(' ');
14 j:=j+2;
15 end loop;
16
17 for k in 1..i
18 loop
19 dbms_output.put('* ');
20 end loop;
21 dbms_output.new_line;
22 i:=i+2;
23 end loop;
24
25 i:=7;
26 while i>=1
27 loop
28 j:=9;
29 while j>i
30 loop
31 dbms_output.put(' ');
32 j:=j-2;
33 end loop;
34
35 for k in 1..i
36 loop
37 dbms_output.put('* ');
38 end loop;
39 dbms_output.new_line;
40 i:=i-2;
41 end loop;
42 end;
43 /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
2 n INTEGER;
3 i INTEGER:=1;
4 j INTEGER;
5 k INTEGER;
6 BEGIN
7 n:=&n;
8 WHILE i<n
9 loop
10 j:=1;
11 WHILE j<n-i
12 loop
13 dbms_output.put(' ');
14 j:=j+2;
15 end loop;
16
17 for k in 1..i
18 loop
19 dbms_output.put('* ');
20 end loop;
21 dbms_output.new_line;
22 i:=i+2;
23 end loop;
24
25 i:=7;
26 while i>=1
27 loop
28 j:=9;
29 while j>i
30 loop
31 dbms_output.put(' ');
32 j:=j-2;
33 end loop;
34
35 for k in 1..i
36 loop
37 dbms_output.put('* ');
38 end loop;
39 dbms_output.new_line;
40 i:=i-2;
41 end loop;
42 end;
43 / 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
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 Pattern Code 1
SQL> DECLARE
2 n INTEGER;
3 i INTEGER:=1;
4 j INTEGER;
5 k INTEGER;
6 BEGIN
7 n:=&n;
8 WHILE i<n
9 loop
10 j:=1;
11 WHILE j<n-i
12 loop
13 dbms_output.put(' ');
14 j:=j+2;
15 end loop;
16
17 for k in 1..i
18 loop
19 dbms_output.put(k);
20 dbms_output.put(' ');
21
22 end loop;
23 dbms_output.new_line;
24 i:=i+2;
25 end loop;
26
27 i:=7;
28 while i>=1
29 loop
30 j:=9;
31 while j>i
32 loop
33 dbms_output.put(' ');
34 j:=j-2;
35 end loop;
36
37 for k in 1..i
38 loop
39 dbms_output.put(k);
40 dbms_output.put(' ');
41 end loop;
42 dbms_output.new_line;
43 i:=i-2;
44 end loop;
45 end;
46 / 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
2 n INTEGER;
3 i INTEGER:=1;
4 j INTEGER;
5 k INTEGER;
6 BEGIN
7 n:=&n;
8 WHILE i<n
9 loop
10 j:=1;
11 WHILE j<n-i
12 loop
13 dbms_output.put(' ');
14 j:=j+2;
15 end loop;
16
17 for k in 1..i
18 loop
19 dbms_output.put(k);
20 dbms_output.put(' ');
21
22 end loop;
23 dbms_output.new_line;
24 i:=i+2;
25 end loop;
26
27 i:=7;
28 while i>=1
29 loop
30 j:=9;
31 while j>i
32 loop
33 dbms_output.put(' ');
34 j:=j-2;
35 end loop;
36
37 for k in 1..i
38 loop
39 dbms_output.put(k);
40 dbms_output.put(' ');
41 end loop;
42 dbms_output.new_line;
43 i:=i-2;
44 end loop;
45 end;
46 / 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.
Leave a Reply