DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: What is the maximum number of items that can be put in the "IN LIST" of SQL QUERY?

  1. 12-21-2006, 03:56 PM #1
    newbie5
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    What is the maximum number of items that can be put in the "IN LIST" of SQL QUERY?

    Does anyone know what is the maximum number of items that can be included in an “IN LIST” SQL statement in Oracle 10g?

    Does a limit exist either on the number of values or length of the string in the IN CLAUSE of a SQL?
    Reply With Quote Reply With Quote
  2. 12-21-2006, 04:01 PM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    I think a single SQL statement cannot exceed 32k size.
    Does your SQL crosses the limit?

    Tamil
    Reply With Quote Reply With Quote
  3. 12-21-2006, 04:35 PM #3
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Is there some reason that you don't store those values in a table???
    I would say that the practical limit is much less than the technical limit.
    Reply With Quote Reply With Quote
  4. 12-21-2006, 06:32 PM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by gandolf989
    Is there some reason that you don't store those values in a table???
    I would say that the practical limit is much less than the technical limit.
    yes, the fundamental question here is WHY?
    Jeff Hunter
    Reply With Quote Reply With Quote
  5. 12-21-2006, 10:37 PM #5
    ebrian
    ebrian is offline Senior Member
    Join Date
    Apr 2006
    Posts
    377
    A comma-delimited list of expressions can contain no more than 1000 expressions, however as the others have indicated, I would consider the practical limit much lower than this.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width