EcalCondDB/sql/pvss_getaliasfordevice_func.sql

0001 CREATE OR REPLACE
0002 function getAliasForDevice(DPEName in varchar2) return varchar2 is
0003         alias aliases.alias%type;
0004         DPName varchar2(1000);
0005         dotLocation number;
0006 begin
0007         --get the name of the DP itself, not an element
0008         dotLocation:=instr(DPEName,'.');
0009         if dotLocation>0 then
0010                 DPName:=substr(DPEName,1,dotLocation);
0011         end if;
0012         select alias into alias from (select alias from aliases where dpe_name=DPName order by since desc) where rownum=1;
0013         --perhaps should do something if there is no record... but for now I think we want there to always be one.
0014         return alias;
0015 end;
0016 /
0017 show errors;