Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?

Just use multiple in-clauses to get around this:

select field1, field2, field3 from table1 
where  name in ('value1', 'value2', ..., 'value999') 
    or name in ('value1000', ..., 'value1999') 
    or ...;

Related Posts:

  1. ORA-01735: invalid ALTER TABLE option – Toad
  2. What is the difference between UNION and UNION ALL?
  3. Selecting COUNT(*) with DISTINCT
  4. ORA-00904: invalid identifier
  5. Unknown column in ‘field list’ error on MySQL Update query
  6. When should I use CROSS APPLY over INNER JOIN?
  7. Insert Data Into Temp Table with Query
  8. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  9. SQL SELECT WHERE field contains words
  10. Using group by on multiple columns
  11. Efficiently convert rows to columns in sql server
  12. Nested select statement in SQL Server
  13. What’s the difference between VARCHAR and CHAR?
  14. How to split the name string in mysql?
  15. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  16. Sql Server equivalent of a COUNTIF aggregate function
  17. Column name or number of supplied values does not match table definition
  18. Inserting data into a temporary table
  19. How to Select Top 100 rows in Oracle?
  20. Simple PHP Pagination script
  21. ORA-12560: TNS:protocol adaptor error
  22. How can I select the first day of a month in SQL?
  23. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  24. SQL – HAVING vs. WHERE
  25. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  26. Oracle Apex column link from LOV values
  27. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  28. When to use “ON UPDATE CASCADE”
  29. MySQL combine two columns into one column
  30. How to SUM two fields within an SQL query
  31. DateTime2 vs DateTime in SQL Server
  32. ORA-01861: literal does not match format string
  33. Difference between numeric, float and decimal in SQL Server
  34. SQL Server Insert if not exists
  35. SQL Server: Invalid Column Name
  36. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  37. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  38. How do I query for all dates greater than a certain date in SQL Server?
  39. String or binary data would be truncated. The statement has been terminated
  40. Error converting data type varchar to float
  41. How to concatenate text from multiple rows into a single text string in SQL Server
  42. Cast from VARCHAR to INT – MySQL
  43. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  44. postgresql: error duplicate key value violates unique constraint
  45. how to remove time from datetime
  46. “You tried to execute a query that does not include the specified aggregate function”
  47. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  48. How to round down to nearest integer in MySQL?
  49. How do I reset a sequence in Oracle?
  50. Query to convert from datetime to date mysql
  51. MySQL error: key specification without a key length
  52. SQL: Two select statements in one query
  53. How to query MongoDB with “like”
  54. Check if MySQL table exists without using “select from” syntax?
  55. MySQL equivalent of DECODE function in Oracle
  56. mysql update column with value from another table
  57. SQL Server dynamic PIVOT query?
  58. How to copy a row and insert in same table with a autoincrement field in MySQL?
  59. Error converting data type varchar
  60. I want to use CASE statement to update some records in sql server 2005
  61. What does Include() do in LINQ?
  62. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  63. Get everything after and before certain character in SQL Server
  64. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  65. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  66. ROW_NUMBER() in MySQ
  67. LEFT function in Oracle
  68. Foreign key references invalid table
  69. Postgresql column reference “id” is ambiguous
  70. Inner Joining three tables
  71. How do I view the Explain Plan in Oracle Sql developer?
  72. ORA-01779: cannot modify a column which maps to a non key-preserved table
  73. SUM OVER PARTITION BY
  74. SQLite string contains other string query
  75. Varchar invalid for Sum operator
  76. SQL: How to properly check if a record exists
  77. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  78. Sorting search results by taxonomy terms
  79. SQL select of users by metadata
  80. How to properly sanitize strings without $wpdb->prepare?
  81. WordPress SQL LIKE request doesn’t work for fields with special symbols
  82. posts_where Fails with More than One Custom Field in Query
  83. Restose content from revisions – sql query
  84. Better way to migrate to server?
  85. Inner Join user tables to select users with roles
  86. $wpdb->prepare with LIKE returning blank array instead of rows
  87. Removing posts by sql
  88. Why line returns are not reapply after doing esc_sql?
  89. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  90. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  91. Help me SELECT thumbnail from SQL and use
  92. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  93. Search results sort order failing: set by date only
  94. Creating a “forum” – showing last post or last commented post
  95. Replace Unwanted Space in Post Content URL
  96. SQL to transform all email addresses in my DB in lowercase [closed]
  97. How to write inner join using posts_clauses?
  98. How to get the sum of each post with the same date
  99. How to dump a Microsoft SQL Server database to a SQL script?
  100. Deleting the MySQL database

Leave a Comment

tech