Re: Select ROWID with a criteria

It would be meaningless even if you could as the sequence of ROWIDs does not necessarily bear ANY relationship to the data they refer to or the order in which the data was inserted into the table.

ETA "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<XJFra.10490$kI3.8006_at_fed1read03>...
> Marcelo Muzilli wrote:
> > Hi all,
> > how can I select a range of rows using rowid number
> >
> > For example, I would like to select this range of rows:
> >
> > SELECT EMP_NAME FROM EMP WHERE ROWID(EMP) >= 10 AND
> > ROWID(EMP) <= 1000;
> >
> > I think that you can understand this clause.
> >
> > Thanks in advance,
> >
> > ---
> > Marcelo Muzilli
> > Support Engineer
> > UIN: 1572797
> > marcelo_muzilli_at_hotmail.com
>
> You can NOT "select a range of rows using rowid number.
Received on Wed Apr 30 2003 - 11:17:26 CEST