Oracle 中带子查询的视图:
CREATE OR REPLACE VIEW MOCHA_IM_ALL_ACCOUNT_VIEWS
SELECT USER_ID AS ID, USER_NAMEAS NAME, CONCAT(CONCAT(CONCAT(NVL,'
00000001.'), '.00.'), , LPAD,9,'O')) AS CODE, NVL, 1) AS REC_LEVEL,'
PERSON' AS REC_TYPE
FROM (SELECT , , NVL, -1) AS ORG_ID, NVL, 0) AS ORG_PERSON_NO
,NVL, '64') AS PERSON_LEVELFROM MOCHA_IM_PERSON_POSITIOPOSITION, MO
CHA_IM_PERSONPERSON WHERE =
ITION, MOCHA_IM_ORG_VIEVORG
(+) AND '0' And ='A') PERSON_POS
WHERE
(+)
UNION ALL
SELECT USER_ID AS ID, USER_NAMEAS NAME, '00000001..'
AS REC_LEVEL, 'PERSON' AS REC_TYPE
AS CODE, 1
FROM MOCHA_IM_PERSOPERSON WHERE = '0' And ='I'
UNION ALL
SELECT USER_ID AS ID, USER_NAMEAS NAME, '00000001..' AS CODE
,1 AS REC_LEVEL, 'PERSON' AS REC_TYPE
FROM MOCHA_IM_PERSONVHERE ADMIN_FLAG = '1' AND STATUS='A'
UNION ALL
SELECT LPAD(ORG_ID,20,' ') AS ID, ORG_NAMEAS NAME, ORG_CODEAS
CODE,ORG_LEVELAS REC_LEVEL, 'ORG' AS REC_TYPE FROM MOCHA_IM_ORG_VIEW
UNION ALL
SELECT '-1' AS ID,'未分派人员
'AS NAME, '00000001.' AS CODE, 1 AS REC_LEVEL, 'ORG' AS REC_TYPE F
UNION ALL