pl/sql打印_PL / SQL程序打印图案

雨点打透心脏的1/2处 2022-12-07 13:53 228阅读 0赞

![8d028dec301d5ccd13398add56595986.png][]

pl/sql打印

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

在这里，您将获得plsql程序来打印星，数字和字母的模式。

**Pattern 1:**

**模式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:**

**模式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:**

**模式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:**

**模式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:**

**模式5：**

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

**Pattern 6:**

**模式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:**

**模式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.

如果您需要任何其他模式，请在下面评论。 我将尝试在此处添加它。

> 翻译自: [https://www.thecrazyprogrammer.com/2017/10/plsql-program-print-patterns.html][https_www.thecrazyprogrammer.com_2017_10_plsql-program-print-patterns.html]

pl/sql打印

[8d028dec301d5ccd13398add56595986.png]: /images/20221123/569c2da86f45439793bcb2a2604f94d5.png
[https_www.thecrazyprogrammer.com_2017_10_plsql-program-print-patterns.html]: https://www.thecrazyprogrammer.com/2017/10/plsql-program-print-patterns.html