create function pro(p_date in date)
return varchar2
as
num number;
begin
select count(1) into num from table_name where col_date=p_date;
if num>0 then
if p_date=sysdate then
return '一致';
else
return '不一致';
end if;
end if;
return 'A不存在的信息';
end;
/
return varchar2
as
num number;
begin
select count(1) into num from table_name where col_date=p_date;
if num>0 then
if p_date=sysdate then
return '一致';
else
return '不一致';
end if;
end if;
return 'A不存在的信息';
end;
/
(expr [, expr]...) [INTO :ret_var [[INDICATOR] :ret_ind]]