create or replace function function1(para1 in number, para2 in number)
return number as
begin
if para1 > para2 then
return para1;
elsif para2 > para1 then
return para2;
else
return 0;
end if;
end function1;
-----
select function1(666, 1333) from dual;
-----
-----
DECLARE
bigVlaue NUMBER;
BEGIN
bigVlaue:=function1(21,2);
if bigVlaue=0 then
dbms_output.put_line('数字相同');
else
dbms_output.put_line('bigVlaue:'||bigVlaue);
end if ;
END;
Oracle中的函数例子
最新推荐文章于 2021-04-02 19:40:45 发布