So I can’t create or edit tables (I’m a user with read only permission) and I want to look up 10,000 unique id’s. I can’t put them inside of an IN() statement because oracle limits over 1000 items. Is it possible to select this entire list from the DUAL table in oracle? Something like: Answer Use a collection (they are