Mysql\Oracel中数据字典转换函数

CREATE OR REPLACE FUNCTION getDict(dict VARCHAR2,dict_code VARCHAR2)
RETURN VARCHAR2 IS
dict_name F_DATADICTIONARY.DATAVALUE%type;
BEGIN
SELECT DATAVALUE into dict_name
FROM F_DATADICTIONARY
WHERE CATALOGCODE = dict and DATACODE=dict_code;
RETURN dict_name;
END ;

 

 

 

 decode(t.jgsy_chaojg, '0','空机构','1','正常', '2','超机构',t.jgsy_chaojg)jgsyChaojgText

 

 

Mysql

函数

CREATE FUNCTION getDict(dict VARCHAR(100), dictValue VARCHAR(100))
RETURNS VARCHAR(100)
READS SQL DATA
BEGIN
  DECLARE returnValue VARCHAR(100);
  SELECT dict_label INTO returnValue
  FROM sys_dict_data
  WHERE sys_dict_data.dict_type = dict AND sys_dict_data.dict_value = dictValue;
  RETURN returnValue;
END