SQL Oracle - Select more than 1000 rows from file

Question

I have a problem with a query in which a file containing over 1000 rows is loaded.

SELECT * 
FROM table1 
WHERE items IN(%NewListVar%)

The database returns this error:

[Ora]ORA-01795: maximum number of expressions in a list is 1000

Is it possible to divide loading rows or workaround this limit?

If the values are in a file, how do you get them into the database? — APC, Oct 30 '18 at 07:03

score 1 · Answer 1 · answered Oct 30 '18 at 06:14

1

Insert values into temp table and then join the temp table on this values

answered Oct 30 '18 at 06:14

Ori Marko

1 Answers1