Re: Next 33

"Mark C. Stock" wrote:
>
> "Michael Hill" <hillmw_at_ram.lmtas.lmco.com> wrote in message
> news:40479F09.C62F9BE4_at_ram.lmtas.lmco.com...
> | I have some query like:
> |
> | select my_field from my_table
> |
> | and there are 500000 rows in the table, how do I tell Oracle to display
> | the next 33?
> |
> | i tried select my_field from my_table next 33 and it doesn't like it.
> |
> | Mike
>
> are you familiar with the WHERE clause?
>

yes and so using the where clause gets me from 500000 rows to 25000

> what version of oracle are you using?
>

Dont know for sure at least 8. something I think.

> what is your interface (tool)?
>

I am using perl dbi and so I'd like to limit the number number of records using the query statement. Some tools do that for you as does coldfusion.

> ;-{ mcs
Received on Sat Mar 06 2004 - 02:17:52 CET