create or replace function GetSupName(pid in varchar2) return varchar2 is
ret varchar2(10);
begin
select orgname into ret from organization
where orgid=pid;
return(ret);
end GetSupName;--这样调用
select a.orgId,
a.orgName,
GETSUPNAME(a.pid) as supname,----------------------------
a.orgCnShort,
a.orgEnName,
a.orgEnShort,
a.orgLeader,
a.dutyTel,
a.email,
a.faxTel,
a.orgAddr,
decode(a.externalFlag,1,'是',0,'否') as externalFlag,
decode(a.postFlag,1,'否',0,'是') as postFlag
from organization a
ret varchar2(10);
begin
select orgname into ret from organization
where orgid=pid;
return(ret);
end GetSupName;--这样调用
select a.orgId,
a.orgName,
GETSUPNAME(a.pid) as supname,----------------------------
a.orgCnShort,
a.orgEnName,
a.orgEnShort,
a.orgLeader,
a.dutyTel,
a.email,
a.faxTel,
a.orgAddr,
decode(a.externalFlag,1,'是',0,'否') as externalFlag,
decode(a.postFlag,1,'否',0,'是') as postFlag
from organization a
看看
ret varchar2(10);
begin
select orgname into ret from organization
where orgid=v_pid;
return(ret);
end GetSupName;
表organization中存在名为pid的字段了。
--这样调用
select a.orgId,
a.orgName,
GETSUPNAME(a.pid) as supname,----------------------------
a.orgCnShort,
a.orgEnName,
a.orgEnShort,
a.orgLeader,
a.dutyTel,
a.email,
a.faxTel,
a.orgAddr,
decode(a.externalFlag,1,'是',0,'否') as externalFlag,
decode(a.postFlag,1,'否',0,'是') as postFlag
from organization a函数也是对同一个表作用,使用连接表来做达不到效果才考虑使用函数来实现的