1. 利用已有的表将 code值转化
CREATE OR REPLACE FUNCTION "GETUSERNAME" (pUserID varchar2)
return varchar2is
pUserName varchar2(80) ;
begin
select UserName into pUserName from user_info where userid = pUserID;
return pUserName;
EXCEPTION
WHEN NO_DATA_FOUND THEN return pUserID;
end;
2. 利用新建的表,然后通过 在新建的表里面添加code ,然后通过 函数转换
CREATE OR REPLACE FUNCTION "GETITEMNAME" (pCodeNo varchar2,pItemNo varchar2)
return VARCHAR2
IS
pItemName varchar2(200) ;
BEGIN
--
select ItemName into pItemName
from Code_Library
WHERE codeno=pcodeno AND ItemNo=pItemNo;
if pItemName is null then
return pItemNo;
else
return pItemName;
end if;
exception when others then return pItemNo;
end ;