Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Database Application Development
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 27, 2012 7:10 AM by
IN operator Alternate ?
Nov 27, 2012 6:36 AM
I have 25000 values to check whether it is exist or not. Using In operator I can pass only 1000 values at a time. Can we have anyother method to check the values.
This content has been marked as final.
Show 1 reply
Re: IN operator Alternate ?
Nov 27, 2012 7:10 AM
in response to
First you should ask this question in the SQL and PL/SQL forum
this forum is for the SQLDeveloper tool.
Nevertheless if you put your 25000 records in a temporary table then you can use the IN operator just fine, the 1000 limit exists only if you manually type all the records.
something like this in your case should work
SELETC * FROM [TARGET_TABLE] WHERE [TARGET_COLUMN] IN ( SELECT FILTER_COL FROM TMP_FILTER );
where TMP_FILTER is a temporary table contanining your 25000 values.