Toad World® Forums

How can I maximise number of expressions .

My query limits me to only enter 1000 variables while giving any coditions . for e.g. I want to pull Prices of all the products with product codes ( 1, 34, 23, 345 ,2 , 345, 34, 89, 3453, … n)

These are 3000 random product codes which I want to edit under condition. but system only allows me to add 1000 .

That’s Oracle’s max. And to be honest, it is not a great idea to make an ‘in’ list of 1000 items. It’s a lot of work for Oracle to parse that query, and it’s
likely to never be reused.

Can you do something like this:

Select *

from table

where product_code in (select product codes from some other table where …)

From: simmig [mailto:bounce-simmig@toadworld.com]

Sent: Tuesday, June 18, 2013 3:58 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] How can I maximise number of expressions .

My query limits me to only enter 1000 variables while giving any coditions . for e.g. I want to pull Prices of all the products with product codes ( 1, 34, 23, 345 ,2 , 345, 34, 89, 3453, …
n)

These are 3000 random product codes which I want to edit under condition. but system only allows me to add 1000 .