select LOCAL_ID BUSINESS_ID BASIC_ACTIVE_ID replacereplacereplaceCONVERTvarchar ConvertdatetimeDATAGENERATE_DATE 120 - DATAGENERATE_DATE ORGANIZATION_CODE ORGANIZATION

在Oracle中，你可以使用TO_CHAR函数将日期字段转换为字符串，并在需要时进行条件判断。以下是修改后的查询语句：

SELECT 
    [LOCAL_ID],
    [BUSINESS_ID],
    [BASIC_ACTIVE_ID],
    REPLACE(REPLACE(REPLACE(TO_CHAR(DATAGENERATE_DATE, 'YYYY-MM-DD HH24:MI:SS'), '-', ''), ' ', ''), ':', '') AS DATAGENERATE_DATE,
    [ORGANIZATION_CODE],
    [ORGANIZATION_NAME],
    [UNIQUEID],
    [DATA_STATE],
    [DE02_01_039_001],
    [DE02_01_040_00],
    [CT02_01_040_01],
    [DE02_01_026_01],
    [DE02_01_032_02],
    [DE01_00_014_01],
    [DE02_10_090_01],
    [DE08_10_054_01],
    [DE01_00_019_01],
    [DE01_00_026_01],
    [WS01_00_903_01],
    [WS01_00_904_01],
    [WS01_00_907_01],
    [DE06_00_286_00],
    [CT06_00_286_01],
    [DE06_00_289_00],
    [CT06_00_289_01],
    [WS06_00_288_01],
    [CT06_00_288_01],
    [DE06_00_288_00],
    [WS06_00_900_01],
    [WS08_50_025_01],
    [CT08_50_025_01],
    [WS08_50_923_01],
    [CT08_50_923_01],
    [DE08_50_043_00],
    [DE08_50_011_00],
    [CT08_50_011_01],
    [DE06_00_134_00],
    [CT06_00_134_01],
    [DE08_50_047_00],
    [WS08_50_937_01],
    [WS06_00_133_02],
    [CT08_50_931_02],
    [WS08_50_931_02],
    [DE08_50_023_00],
    [DE06_00_135_00],
    [DE08_50_024_00],
    [DE06_00_133_01],
    [CT06_00_133_01],
    [WS04_50_900_02],
    [WS08_50_900_01],
    [DE06_00_179_01],
    [DE06_00_220_01],
    [AP02_01_038_16],
    [DE02_01_039_014],
    [DE06_00_222_01],
    [DE06_00_219_00],
    [DE06_00_205_00],
    [AP02_01_038_29],
    [DE02_01_039_015],
    [DE06_00_222_02],
    [AP06_00_200_00],
    [AP02_01_038_17],
    [DE02_01_039_016],
    [DE06_00_218_02],
    [AP02_01_038_53],
    [DE02_01_039_017],
    [WS02_01_039_018],
    [WS06_00_914_01],
    [WS02_01_039_019],
    [WS06_00_915_01],
    CASE WHEN EXTRACT(YEAR FROM DE06_00_234_00) = 1900 THEN '' ELSE TO_CHAR(DE06_00_234_00, 'YYYY-MM-DD') END AS DE06_00_234_00,
    [DE02_01_039_020],
    [DE06_00_147_00],
    [AP06_00_003_00],
    [AP06_00_197_00],
    [DE08_10_025_10],
    [CT08_10_025_10],
    [DE08_10_025_11],
    [CT08_10_025_11],
    [DE08_10_052_01],
    [CT08_10_052_01],
    [WS99_99_900_01],
    [WS99_99_901_02],
    [WS99_99_902_03],
    [WS99_99_903_04]
FROM 
    [dbo].HDI_DRUREC_INFO

这样，你就可以将查询结果从SQL Server传输到Oracle，并正确处理日期字段