1 Reply Latest reply: Nov 27, 2012 7:10 AM by Irian RSS

    IN operator Alternate ?

    venkatraman.L
      Hi,

      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.

      Thanks,
      Venkataraman L
        • 1. Re: IN operator Alternate ?
          Irian
          First you should ask this question in the SQL and PL/SQL forum
          SQL and PL/SQL
          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.