Re: [OJB-developers] multiple classes mapped to single table request for comments

[Oleg N. <on...@ib...>]

Jakob Braeuchi wrote:
> hi matthew,

>> I thought about using IN, but doesn't that have a length limit? Maybe
> that's
>> not important for extents (people should inherit THAT much :))

> afaik IN has (or at least had in previous versions) a length limit of 254 in
> Oracle.
I don't think this is true about Oracle, but I know that there is a
limit of 250 OR's and AND's in WHERE clause for Sybase ASE.
IN is equivalent to the sequence of OR's, so it also has the limit of
250 elements, but there is no difference between IN and OR's from
DB server point of view, but IN syntax is shorter.

Oleg