pl/sql查找表_PL / SQL程序查找三个数中的最大值

pl/sql查找表

Here you will get plsql program to find greatest of three numbers.

在这里，您将获得plsql程序以查找三个数字中的最大值。

declare
	a number:=10;
	b number:=12;
	c number:=5;
begin
	dbms_output.put_line('a='||a||' b='||b||' c='||c);
	if a>b AND a>c
	then
		dbms_output.put_line('a is greatest');
	else
		if b>a AND b>c
		then
			dbms_output.put_line('b is greatest');	
		else
			dbms_output.put_line('c is greatest');
		end if;
	end if;
end;
/

Output

输出量

a=10 b=12 c=5 b is greatest

a = 10 b = 12 c = 5 b最大

翻译自: https://www.thecrazyprogrammer.com/2017/10/plsql-program-find-greatest-three-numbers.html

pl/sql查找表