0 Replies Latest reply: Nov 30, 2006 11:54 AM by Dan Bracuk RSS

    Upper Limit on Lists for Q of Q

    Dan Bracuk Community Member
      Consder the following sql

      select somefields
      from atable
      where afield in (somelist)

      In Oracle, there is a limit on the number of items somelist can contain. In 9i for example, the limit is 1000.

      Has anyone come across a limit for query of queries? I've successfully run queries where the list had roughly 1500 items in it, so if there is a limit, I know it's higher than tha.