【无标题】

创建oracle 自定义函数

CREATE OR REPLACE FUNCTION F_GETMC(bmid in nvarchar2) return nvarchar2 is
  bmmc nvarchar2(100);
BEGIN
  SELECT mc INTO bmmc
  FROM (select distinct recordid,mc from
    (SELECT recordid,ygxm AS mc FROM gy_ygxx 
    UNION ALL
    SELECT recordid,mc FROM gy_yqbmksxx 
    UNION ALL
    SELECT recordid,zdmc FROM gy_zdwh 
    UNION ALL
    SELECT recordid, wzmc FROM gy_wzxx
    UNION ALL
    SELECT recordid, GYSMC FROM gy_gys 
    UNION ALL
    SELECT recordid,XMMC FROM gy_fyml 
  )) WHERE recordid = bmid;

   RETURN bmmc;
-- 可根据需求修改，处理找不到数据的情况
END;