SELECT id
FROM (SELECT rownum + 100000000 id
FROM dual
CONNECT BY level < 1e9
) tax_ids
WHERE NOT EXISTS ( SELECT NULL
FROM ap_suppliers
WHERE num_1099 = tax_ids.id
)
FROM (SELECT rownum + 100000000 id
FROM dual
CONNECT BY level < 1e9
) tax_ids
WHERE NOT EXISTS ( SELECT NULL
FROM ap_suppliers
WHERE num_1099 = tax_ids.id
)
No comments:
Post a Comment