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

Thread: IN Clause Q?

  1. #1
    Join Date
    Nov 2001
    Posts
    55

    Talking

    In where clause of select statement IN condition have any limit in number of elements? eg WHERE field1 IN (1,2,3,4,5,6,7, etc).

    ThanX
    Raj

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    I had limits with Oracle 7, about 255 values;
    I do not know if it's still so limitied with Oracle 8+, ++

    Orca

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Orca777
    I had limits with Oracle 7, about 255 values;
    I do not know if it's still so limitied with Oracle 8+, ++

    Orca
    I think it is 1000 fro 8i. Parhaps for 9i too.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

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


Click Here to Expand Forum to Full Width