将一张表的字段作为视图字段
create or replace view hra00_department as
select id,
DEPT_CODE as DEPARTMENT_CODE,
DEPT_NAME as DEPARTMENT_CHINESE_NAME,
INPUT_CODE,
REMARK,
SORT_ORDER,
PARENT_ID,
ORG_ID as HEALTH_SERVIE_ORG,
IS_VALID as IS_VAILD,
MODIFY_USER_ID,
MODIFY_TIME,
'300' as DEPARTMENT_RANK,
'100' as DEPARTMENT_NATURE
from ECI_SYS_SERVICE_DEPT;