grimlockpdp
Thread Starter
- Joined
- Sep 22, 2009
- Messages
- 26
I am trying to run the following query below in Oracle:
Select Acct_Num, Customer_Name
From Database
Where Acct_Num IN (
1,
2,
..,
..,
200001,
200002
)
When I attempt to run the query, I get the error message: "ORA-01795 maximum number of expressions in a list is 1000"
Is there any way I can execute this query w/o having to break the list up by 1,000 Acct_Num over 200 times? Please note that there are more than 200,002 accounts and I just want to extract information on these 200,002 accounts. Thank you!!
Select Acct_Num, Customer_Name
From Database
Where Acct_Num IN (
1,
2,
..,
..,
200001,
200002
)
When I attempt to run the query, I get the error message: "ORA-01795 maximum number of expressions in a list is 1000"
Is there any way I can execute this query w/o having to break the list up by 1,000 Acct_Num over 200 times? Please note that there are more than 200,002 accounts and I just want to extract information on these 200,002 accounts. Thank you!!