This content has been marked as final. Show 3 replies
which 100000 records do you need? Are they random chosen, is it a range, does it start with some letter or something else, are it the latest addition?
If you know that answer, then you can write a SQL according to it. How did you otherwise type 100000 "cases"?
Herald ten Dam
yes. insert comma separted list into table or cast as table and use query as subquery of in clause.
you can comma separated into table using sys.dbms_debug_vc2coll(1,2,3)
Store your IN list values as data in a (global temporary) table and join to that.