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

函数

?

1 2 3 4 5 6 7 8 9 10

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