3 Replies Latest reply: Jul 2, 2012 6:07 AM by Hoek RSS

    error ORA-01795

    Costa
      Hi all,

      I have to retrieve data from database for around 1 lakh cases(with this format PHEH2006US04085 etc)

      When I retrieve the data, I am getting error like ORA-01795: maximum number of expressions in a list is 1000

      create table x as select cases from table1 where cases in ('PHEH2006US04085', etc.........)

      When I browse in the net, I found that IN operator supports only 1000 cases at a time. So I have to write 100 times for this.
      Is there any alternative way ..