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;
/

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;
/

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;
/

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;
/

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;
/

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;
/

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;
/

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.

49 thoughts on “PL/SQL Program to Print Patterns”

varma
December 17, 2017 at 5:12 pm

Hi, I need oracle query for the given pattern.
1
12
123
1234

Reply
1. akash ithape
  February 20, 2018 at 7:42 am
  
  declare
  n number:=5;
  i number;
  j number;
  begin
  for i in 1..n
  loop
  for j in 1..i
  loop
  dbms_output.put(‘1’);
  end loop;
  
  dbms_output.new_line;
  end loop;
  end;
  /
  
  Reply
2. akash ithape
  February 20, 2018 at 7:44 am
  
  this is your required program
  
  Reply
  1. ddl
    March 19, 2018 at 9:57 am
    
    hello akash,
    
    Dont give wrong program
    
    Reply
    1. ddl
      March 19, 2018 at 9:58 am
      
      declare
      n number:=5;
      i number;
      j number;
      begin
      for i in 1..n
      loop
      for j in 1..i
      loop
      dbms_output.put(‘J’);
      end loop;
      dbms_output.new_line;
      end loop;
      end;
      /
      
      Reply
3. Amol
  August 27, 2018 at 2:30 pm
  
  Declare
  n number(1);=5:
  i nimber(1):
  j number (1):
  Begin
  For i in 1..n
  loop
  for j in j..i
  loop
  dbms_output.put(j):
  end loop:
  dbms_output.new_line:
  end loop:
  End:
  /
  
  Reply
4. bhargav
  January 9, 2019 at 10:55 am
  
  declare
  n number:=5;
  i number;
  j NUMBER := 1;
  begin
  FOR k IN 1..n LOOP
  i:=i||j;
  j:=j+1;
  dbms_output.put_line(i);
  END LOOP;
  END;
  
  Reply
5. siddharh
  March 28, 2019 at 5:24 am
  
  declare
  i number;
  
  k number;
  n number:=4;
  begin
  for i in 1..n
  loop
  
  k:=1;
  while k<i+1
  loop
  dbms_output.put(k);
  k:=k+1;
  end loop;
  
  dbms_output.new_line;
  end loop;
  end;
  
  Reply
6. karthik
  January 23, 2020 at 7:25 am
  
  declare
  n number:=5;
  i number;
  j number;
  
  begin
  for i in 1..n loop
  for j in 1..i loop
  dbms_output.put(j);
  end loop;
  dbms_output.new_line;
  end loop;
  end;
  /
  
  Reply
7. vikrant singh
  February 12, 2020 at 5:16 pm
  
  set serveroutput on
  declare
  n number:=5;
  i number;
  j number;
  k PLS_integer:=1;
  begin
  for i in 1..n
  loop
  k:=1;
  for j in 1..i
  loop
  dbms_output.put(k);
  k := k+1;
  end loop;
  
  dbms_output.new_line;
  end loop;
  end;
  /
  
  Reply
8. Riyaz
  May 5, 2020 at 6:07 am
  
  DECLARE
  I_NUM NUMBER:=1234;
  PATTERN NUMBER;
  BEGIN
  FOR I IN 1..LENGTH(I_NUM) LOOP
  PATTERN:=SUBSTR(I_NUM,1,I);
  DBMS_OUTPUT.PUT_LINE(PATTERN);
  END LOOP;
  END;
  
  OUTPUT LIKE:
  1
  12
  123
  1234
  
  Reply
9. Chiranth
  August 31, 2020 at 4:53 pm
  
  Declare
  V_num number=1234;
  Begin
  For i in 1..4
  Loop
  Dbms_output.putline(substring(v_num,1,i);
  End loop;
  End;
  
  Reply
10. Vidhyadhar Kokate
  February 9, 2023 at 8:56 pm
  
  BEGIN
  FOR i IN 1..4
  LOOP
  FOR j IN 1..i
  LOOP
  dbms_output.put(j) ;
  END LOOP;
  dbms_output.new_line;
  END LOOP;
  END
  
  Reply
Mark
January 5, 2018 at 6:19 am

Hi
how to print numbers in this format
1 2 3
4 5 6
7 8 9

Reply
1. binod kumar
  January 30, 2019 at 7:43 am
  
  declare
  n number:=3;
  i number ;
  k number :=0;
  j number ;
  begin
  for i in 1..n
  loop
  for j in 1..n
  loop
  dbms_output.put(j+k);
  end loop;
  dbms_output.new_line;
  k:=k+3;
  end loop;
  end;
  
  Reply
2. vikrant singh
  February 12, 2020 at 5:33 pm
  
  set serveroutput on
  declare
  n number:=3;
  i number;
  j number;
  k pls_integer:=1;
  begin
  for i in 1..n
  loop
  for j in 1..n
  loop
  dbms_output.put(k);
  k:=k+1;
  end loop;
  
  dbms_output.new_line;
  end loop;
  end;
  /
  
  Reply
3. Sakthi
  October 27, 2020 at 2:59 pm
  
  Begin
  for i in 1..9
  loop
  DBMS_OUTPUT.PUT(i);
  IF MOD(i,3)=0 THEN
  DBMS_OUTPUT.NEW_LINE;
  CONTINUE;
  END IF;
  End loop;
  END;
  
  Reply
ravi
January 17, 2018 at 11:21 am

pl/sql is not able to add space
declare
n number:=10;
i number:=1;
j number;
k number;
begin
while i<n
loop
j:=1;
while j=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;
/

Reply
ravi
January 17, 2018 at 11:22 am

dbms_output.put(‘ ‘);
this line is not working

Reply
SUMA
February 9, 2018 at 10:40 am

IF AM GIVING INPUT AS 1 THEN I NEED TO GET OUTPUT AS 1,IF INPUT IS 2 THEN OUTPUT SHOULD BE AS 2
2 2
IF INPUT IS 3 THEN OUTPUT SHOULD BE 3
3 3
3 3 3

Reply
1. hari
  September 28, 2019 at 6:25 am
  
  *
  # *
  * # *
  # * # *
  * # * # *
  please help this progarm
  
  Reply
2. Amit Kumar BISWAS
  April 25, 2022 at 4:05 pm
  
  DECLARE
  n NUMBER:=5;
  i NUMBER;
  j NUMBER;
  BEGIN
  FOR i IN 1..n LOOP
  FOR j IN 1..i LOOP
  DBMS_OUTPUT.PUT(i);
  END LOOP;
  DBMS_OUTPUT. NEW_LINE;
  END LOOP;
  END;
  /
  
  Reply
rajesh
March 28, 2018 at 1:10 am

i want pascal triangle

Reply
sanket
March 29, 2018 at 7:06 am

how to print number in this format
1
2 3
4 5 6

Reply
1. vikrant singh
  February 12, 2020 at 5:25 pm
  
  set serveroutput on
  declare
  n number:=3;
  i number;
  j number;
  k pls_integer:=1;
  begin
  for i in 1..n
  loop
  for j in 1..i
  loop
  dbms_output.put(k);
  k:=k+1;
  end loop;
  
  dbms_output.new_line;
  end loop;
  end;
  /
  
  Reply
Prem
September 10, 2018 at 5:09 am

how to print
*
* *
* * *
* * * *
* * * * *

Reply
1. Divya Gupta
  September 19, 2018 at 6:41 am
  
  DECLARE
  I NUMBER;
  J NUMBER;
  BEGIN
  FOR I IN 1..5
  LOOP
  FOR J IN 1..I
  LOOP
  DBMS_OUTPUT.PUT(‘* ‘);
  END LOOP;
  DBMS_OUTPUT.NEW_LINE;
  END LOOP;
  END;
  
  Reply
Sonu
September 15, 2018 at 3:16 pm

Hello!
How to Write a PL/SQL program to print the following series using nested for loop.
0 0 0 0 0
1 2 3 4 5
2 4 6 8 10
3 6 9 12 15
4 8 12 16 20
5 10 15 20 25

Reply
1. Mohammed Almansour
  December 27, 2018 at 6:03 pm
  
  Solve Pattern program is
  
  Declare
  K number;
  I number;
  J number;
  Begin
  For i in 0..5 loop
  K := i ;
  For j in 0..5 loop
  Dbms_output.put_line ( K ) ;
  K:=K+i ;
  End loop;
  Dbms_output.new_line;
  End loop;
  End;
  
  Reply
2. sriharirao
  July 22, 2019 at 5:33 pm
  
  /* 1 2 3 4 5
  2 4 6 8 10
  3 6 9 12 15
  4 8 12 16 20
  5 10 15 20 25 */
  
  DECLARE
  V VARCHAR2(20);
  K VARCHAR2(10);
  L VARCHAR2(10):=0;
  BEGIN
  FOR I IN 1..5 LOOP
  K:=I;
  FOR J IN 1..5 LOOP
  L:=K*J;
  V:=V||’ ‘||L;
  END LOOP;
  DBMS_OUTPUT.PUT_LINE(V);
  V:=NULL;
  END LOOP;
  END;
  /
  
  Reply
3. Sakthi
  October 27, 2020 at 3:59 pm
  
  BEGIN
  FOR i IN 1..3
  loop
  FOR j IN 1..5
  loop
  DBMS_OUTPUT.PUT(i*j);
  END LOOP;
  DBMS_OUTPUT.NEW_LINE;
  END LOOP;
  END;
  
  Reply
Kusum
October 29, 2018 at 5:31 pm

*
**
***
**
*
Pls provide me program for this pattern

Reply
Megha Sharma
January 8, 2019 at 11:53 am

Thank you

Reply
Shwetha
June 11, 2019 at 11:38 pm

Hi, great work!! thanks for all this info here. Could you also tell us how to print just the diagonals of a square?

Reply
krupali
July 31, 2019 at 1:52 pm

Hi
i need this flody’s triangle
1
2 3
4 5 6
7 8 9 10

Reply
Purvi
August 7, 2019 at 12:08 pm

Hii
I also need this flody’s trangle
1
2 3
4 5 6
7 8 9 10

Reply
1. Farzana
  April 29, 2020 at 10:09 pm
  
  declare
  i number:=1;
  j number:=0;
  m number:=1;
  begin
  while(j<4)
  loop
  for k in i..(i+j)
  loop
  dbms_output.put(k);
  end loop;
  dbms_output.new_line;
  j:=j+1;
  i:=i+m;
  m:=m+1;
  end loop;
  END;
  /
  
  Reply
Mouni
August 25, 2019 at 2:28 am

Hlo, can you write code for the below pattern
15,14,13,12,11
10, 9, 8, 7
6, 5, 4
3, 2
1

Reply
darshan ramani
November 22, 2019 at 10:11 am

1,2,3,6,10,15,21
in pl sql

Reply
Darshan Ramani
November 22, 2019 at 10:13 am

4,7, 9, 11,12
if you perform any language

Reply
RK
January 25, 2020 at 9:33 am

I need Pascal’s Triangle with brief introduction
1
1 2 1
1 3 3 1
1 4 6 4 1
1 5 10 10 5 1
1 6 15 20 15 6 1

Reply
PRIYANSHU RAWAT
August 19, 2020 at 4:08 am

I WANT PLSQL CODE TO PRINT NAME IN DECREMENTAL ORDER:
Q
QU
QUE
QUER
QUERY

Reply
1. Suresh K
  November 2, 2020 at 4:33 pm
  
  declare
  var_name varchar2(10):=’QUERY’;
  begin
  for i in 1.. length(var_name)
  loop
  dbms_output.put_line(substr(var_name,1,i));
  end loop;
  end;
  
  Reply
viki patel
October 14, 2020 at 4:30 am

1
2 3
3 4 5
4 5 6 7
5 6 7 8 9
. . . . . . 90 91

i need this type of pattern program please send me

Reply
M. Lakshmi
May 9, 2021 at 6:46 am

1
1 2 1
1 2 3 2 1
1 2 1
1

Reply
bala
September 6, 2021 at 10:44 am

Given string loop and height 10, the magical pattern is
l
loo
loopl
looploo
looploopl
looplooploo
looplooploopl
looplooplooploo
looplooplooploopl
looplooplooplooploo

Reply
Vimal
November 28, 2021 at 4:47 am

How to print following pattern in plsql
1
21
212
1212
12121

How to print this

Reply
1. Muthukumar
  April 11, 2022 at 4:04 am
  
  DECLARE
  n NUMBER:=&n;
  i NUMBER;
  j NUMBER;
  k NUMBER:=1;
  BEGIN
  FOR i IN 0..n-1
  LOOP
  FOR j IN 0..i
  LOOP
  if MOD(k,2) 0 THEN
  dbms_output.put(MOD(k,2));
  else
  dbms_output.put(2);
  
  end if;
  k:=k+1;
  END LOOP;
  dbms_output.new_line();
  END LOOP;
  
  END;
  /
  
  Reply
Amritesh
September 2, 2022 at 7:15 am

Can anybody please help with the pl sql query for fetching and printing data in a row in below pattern?

1~ABC~20-Jun-1998^2~CDE~09-Aug-1987^……

The above data already stored in a table, need here only is to print the fetched data in above pattern

Reply

Related Posts

49 thoughts on “PL/SQL Program to Print Patterns”

Leave a Comment Cancel Reply