pl/sql打印_PL / SQL程序以打印数字表

pl/sql打印

Here you will get pl/sql program to print table of a given number.

在这里，您将获得pl / sql程序以打印给定编号的表。

You can ask your queries in comment section.

您可以在评论部分提问。

declare
	n number;
	i number;
 
begin
	n:=&n;
	
	for i in 1..10
	loop
		dbms_output.put_line(n||' x '||i||' = '||n*i);
	end loop;
end;
/

Output

输出量

Enter value for n: 5 old 6: n:=&n; new 6: n:=5; 5 x 1 = 5 5 x 2 = 10 5 x 3 = 15 5 x 4 = 20 5 x 5 = 25 5 x 6 = 30 5 x 7 = 35 5 x 8 = 40 5 x 9 = 45 5 x 10 = 50

输入n的值：5 旧6：n：=＆n; 新6：n：= 5； 5 x 1 = 5 5 x 2 = 10 5 x 3 = 15 5 x 4 = 20 5 x 5 = 25 5 x 6 = 30 5 x 7 = 35 5 x 8 = 40 5 x 9 = 45 5 x 10 = 50

翻译自: https://www.thecrazyprogrammer.com/2016/09/plsql-program-print-table-number.html

pl/sql打印