-
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
-
I had limits with Oracle 7, about 255 values;
I do not know if it's still so limitied with Oracle 8+, ++
Orca
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|