От: | Funny Rabbit | ||
Дата: | 12.11.19 10:17 | ||
Оценка: |
create or replace function F_GET_KOSGU(nrn in number) return varchar2 is
nKOSGU varchar2(100);
begin
select distinct m.sagngrp
into nKOSGU
from T m
where m.nagent = nrn;
return nKOSGU;
exception
when no_data_found then
return sqlerrm;
when others then
return sqlerrm;
end;
select distinct m.sagngrp
from T m
where m.nagent = 9487598;
select F_GET_KOSGU(9487598)
from dual