从 oracle 函数返回布尔值

2022-01-19 00:00:00 function boolean oracle

试图从函数返回值

create or replace function compairenumber(num1 in number,num2 in number)
return boolean is
begin
if num1 < num2 then
return true;
else 
return false;
end if;
end;

当我提出问题时从对偶中选择compairenumber(5,10)它不返回真或假.

when i'm giving query select compairenumber(5,10) from dual its not returning true or false.

推荐答案

布尔值只能在其他PL/SQL代码中使用,不能在Oracle SQL中使用.如果你想要一个函数,它的返回值在 select ... from dual 中可用,那么你需要定义函数以返回 varchar2 和返回值 'true''false' 分别(或 'T''F',或返回数字,带有值1 和 0).

Boolean values can only be used in other PL/SQL code, not in Oracle SQL. If you want a function whose return value is available in a select ... from dual then you will need to define the function to return varchar2 with the return values 'true' and 'false' respectively (or 'T' and 'F', or return number, with the values 1 and 0).

令人遗憾的是,Oracle SQL 不支持布尔数据类型(尽管编程语言 PL/SQL 支持).

As sad as this is, Oracle SQL does not support the Boolean data type (although the programming language PL/SQL does).

相关文章