Re: maximum number of expressions in a list is 1000

SELECT id, name from anagrafica WHERE id in (...... less than 1000 values) union
SELECT id, name from anagrafica WHERE id in (...... less than 1000 values)

or use a temp table "tmp_id_table" where you add all id's and then use :

SELECT id, name from anagrafica WHERE id in (select * from tmp_id_table)

Best Regards / Venlig Hilsen

Peter Gram

Miracle Consulting <http://www.miracleas.dk> Borupvang 2c, 2750 Ballerup, Denmark
Cell: (+45) 53747107 Home: (+45) 38745696 Office Phone: (+45) 44668855 Office Fax: (+45) 44668856 Mail: peter.gram_at_miracleas.dk
OakTable member <http://www.oaktable.net> <http://www.oaktable.com/>

On 2 January 2013 11:00, Jose Soares <jose.soares_at_sferacarta.com> wrote:

> ORA-01795

--
http://www.freelists.org/webpage/oracle-l