sql脚本

INSERT INTO CD_RET_WELL_DYN(
    WELL_ID,
    START_TIME,
    END_TIME,
    PROD_TIME,
    SUBMITTER_ID,
    SUBMITTER_SHORT_NAME,
    SPARE_C1,
    SPARE_N1
)
SELECT 
    w.well_id,
    TO_DATE('28-03-2026 08:00:00', 'dd-mm-yyyy hh24:mi:ss'),
    TO_DATE('28-03-2026 09:00:00', 'dd-mm-yyyy hh24:mi:ss'),
    TO_DATE('28-03-2026 08:00:00', 'dd-mm-yyyy hh24:mi:ss'),
    'BJ ',
    'XX',
    NULL,
    NULL
FROM cd_bas_we  w
WHERE w.well_id > 24000
  AND NOT EXISTS (
        SELECT 1 
        FROM CD_RET_WELL_DYN  d 
        WHERE d.well_id = w.well_id
  );