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
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 .