oracle - oracle函数中的可空返回类型

Question

是否可以从 oracle 函数返回 null？

我有以下预言机功能:

create or replace function vta.GetAmount(p_month NUMBER)
  return number is
  v_amount number(9);
begin
  select amount
    into v_amount
    from salary
   where salary.month = p_month;
  return v_amount;
end GetAmount;

当 select 语句返回零行时，会引发以下异常: ora-01403: no data found .

在这种情况下，我希望函数返回 null。

Answer 1

create or replace function vta.GetAmount(p_month NUMBER)
  return number is
  v_amount number(9);
begin
  select amount
    into v_amount
    from salary
   where salary.month = p_month;
  return v_amount;
  exception   -- code to handle no data
  when no_data_found then
  return null;
  end GetAmount;