Next 33

[Michael Hill]

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

[Mark C. Stock]

Re: Next 33


"Michael Hill" <hillmw@ram.lmt as.lmco.comwrot e in message
news:40479F09.C 62F9BE4@ram.lmt as.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?

what version of oracle are you using?

what is your interface (tool)?

;-{ mcs

[Michael Hill]

Re: Next 33



"Mark C. Stock" wrote:

>
"Michael Hill" <hillmw@ram.lmt as.lmco.comwrot e in message
news:40479F09.C 62F9BE4@ram.lmt as.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