Re: Select ROWID with a criteria
From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 29 Apr 2003 18:33:44 -0700
Message-ID: <XJFra.10490$kI3.8006_at_fed1read03>
Date: Tue, 29 Apr 2003 18:33:44 -0700
Message-ID: <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 - 03:33:44 CEST