create or replace view VIEW_DICT_COST_APP_DEPT_TYPE as

SELECT APP_DEPT_TYPE_CODE,APP_DEPT_TYPE_NAME FROM (

SELECT ‘A‘ AS APP_DEPT_TYPE_CODE,‘行政后勤类‘ AS  APP_DEPT_TYPE_NAME  FROM DUAL

UNION ALL

SELECT ‘B‘ AS APP_DEPT_TYPE_CODE,‘医疗辅助类‘ AS  APP_DEPT_TYPE_NAME  FROM DUAL

UNION ALL

SELECT ‘C‘ AS APP_DEPT_TYPE_CODE,‘医疗技术类‘ AS  APP_DEPT_TYPE_NAME  FROM DUAL

UNION ALL

SELECT ‘D‘ AS APP_DEPT_TYPE_CODE,‘临床服务类‘ AS  APP_DEPT_TYPE_NAME  FROM DUAL

) a

with read only;

数据库视图