Optimizing Update SQL Query with "WHERE NOT IN (...more than 1000 items...)

Filtering Rows Within an Analytical Function Using Cumulative Aggregation Functions in Oracle