Re: limiting rows in an query

This query (in Oracle) return nothing always
ROWID is unique key and have another form (18 chars) and for two consecutive
rows don't must conescutive ROWID.
regrads

In postgresql jdbc mising get/setFetchSize for Statement (now getFetchSize
return complete query size and for big query we have 'out of memory')
We can user LIMIT, but in another party software (IDE, J2EE server) we must
have setFetchSize)

regards
haris peco

On Monday 30 September 2002 06:56 pm, Felipe Schnack wrote:
> I think there isn't a portable way.
> In Oracle each row of a query have a sequential number, called
> "rowid", I think.
> So, in oracle you do somethink like
> ...AND ROWID >= 0 AND ROWID <20
> Disgusting, isn't it? :-)
>
> On Mon, 2002-09-30 at 13:55, David Wall wrote:
> > Does anybody know how to do this in a "portable" way? For example, I
> > don't think Oracle has the LIMIT clause capability...
> >
> > David