1.表中的WORK_FLOW_TYPE值对应的中文名字不基于数据字典的话,可以用如下sql写法,使用nvl和decode查询出数字值对应的中文名称:
select name,age,
NVL(DECODE(A.WORK_FLOW_TYPE,'1','登记','2','变更','3','取消','4','下放','5','恢复'),' ') as "workFlowTypeName"
from table A
2.如果表中某个字段type(存储的数字类型值 对应数据字典表中的dictId),要获取dictName,则可写如下sql实现:
select name,age,
<![CDATA[
(SELECT WM_CONCAT(DICT_NAME) FROM SYS_DICT_INFO WHERE DICT_CODE='1003' AND INSTR(A.type,DICT_ID)<>0 ) as "typeName"
]]>
from table A