1. 用(+)表示 -- (+)风格
SELECT
TARGET_TABLE.DATASOURCE_NUM_ID,
TARGET_TABLE.INTEGRATION_ID
FROM
X_SRV_CON_LINE_F TARGET_TABLE, X_SRV_CON_LINE_D_PE PE_STAGE_TABLE
WHERE
TARGET_TABLE.INTEGRATION_ID = PE_STAGE_TABLE.INTEGRATION_ID(+) AND
TARGET_TABLE.DATASOURCE_NUM_ID = PE_STAGE_TABLE.DATASOURCE_NUM_ID(+)AND
PE_STAGE_TABLE.INTEGRATION_ID IS NULL AND
PE_STAGE_TABLE.DATASOURCE_NUM_ID IS NULL AND
TARGET_TABLE.DELETE_FLG = 'N' and
TARGET_TABLE.CREATED_ON_DT > TO_DATE('20090424','YYYYMMDD')
2. 在FROM中用关键词'LEFT OUTER JOIN' -- ANSI 风格
SELECT
TARGET_TABLE.DATASOURCE_NUM_ID,
TARGET_TABLE.INTEGRATION_ID
FROM
X_SRV_CON_LINE_F TARGET_TABLE LEFT OUTER JOIN X_SRV_CON_LINE_D_PE PE_STAGE_TABLE ON
TARGET_TABLE.INTEGRATION_ID = PE_STAGE_TABLE.INTEGRATION_ID AND
TARGET_TABLE.DATASOURCE_NUM_ID = PE_STAGE_TABLE.DATASOURCE_NUM_ID
WHERE
PE_STAGE_TABLE.INTEGRATION_ID IS NULL AND
PE_STAGE_TABLE.DATASOURCE_NUM_ID IS NULL AND
TARGET_TABLE.DELETE_FLG = 'N' AND
TARGET_TABLE.CREATED_ON_DT > TO_DATE('20090424','YYYYMMDD')