Oracle 查询不在DB中的数据 SQL

前提：已知ID数组，查询不在DB中table中的ID数据

SQL：

例如:ids为 '111','112','113','...'

 

SELECT ids.id
FROM (SELECT '111' AS id FROM dual UNION ALL
      SELECT '112' AS id FROM dual UNION ALL
      SELECT '113' AS id FROM dual UNION ALL
      SELECT '114' AS id FROM dual UNION ALL
      SELECT '115' AS id FROM dual UNION ALL
      SELECT '116' AS id FROM dual
) ids
LEFT JOIN table_name ON table_name.id = ids.id
WHERE table_name.id IS NULL;