SQL IN Clause 1000 item limit

by

There’s another workaround for this that isn’t mentioned in any of the other answers (or other answered questions):

Any in statement like x in (1,2,3) can be rewritten as (1,x) in ((1,1), (1,2), (1,3)) and the 1000 element limit will no longer apply. I’ve tested with an index on x and explain plan still reports that Oracle is using an access predicate and range scan.

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. SQL Query to concatenate column values from multiple rows in Oracle
  3. Search All Fields In All Tables For A Specific Value (Oracle)
  4. Select First Row of Every Group in sql [duplicate]
  5. Oracle: how to UPSERT (update or insert into a table?)
  6. How do I ignore ampersands in a SQL script running from SQL Plus?
  7. How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
  8. Is it possible to output a SELECT statement from a PL/SQL block?
  9. Oracle SQL, concatenate multiple columns + add text
  10. Oracle query to fetch column names
  11. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  12. SQL Error: ORA-01861: literal does not match format string 01861
  13. Determine Oracle null == null
  14. INSERT SELECT statement in Oracle 11G
  15. Oracle insert if row does not exist
  16. SELECT INTO using Oracle
  17. Display names of all constraints for a table in Oracle SQL
  18. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  19. `show create table` equivalent in oracle sql
  20. Does ‘Select’ always order by primary key?
  21. Query json dictionary data in SQL
  22. ORA-00972 identifier is too long alias column name
  23. How to use a dynamic parameter in a IN clause of a JPA named query?
  24. Search an Oracle database for tables with specific column names?
  25. How to replace specific values in a oracle database column?
  26. ORA-01861: literal does not match format string
  27. Query a Table’s Foreign Key relationships
  28. Backup SQL Schema Only?
  29. IN vs OR of Oracle, which faster?
  30. is there a PRODUCT function like there is a SUM function in Oracle SQL?

Leave a Comment