4 lines
127 B
SQL

create function getOrgName(pOrgID varchar(40)) returns varchar(80)
RETURN (SELECT OrgName FROM org_info WHERE Orgid= pOrgID);