[jeff43015]

Is there a way to start at an only return a certain number of rows from an Oracle table using PHP, I've accomplished this in another scripting language(Net.Data) where you can set the starting row and the total number of rows to return.

for example: starting row = 1 total rows = 11 returns the first eleven rows for an sql statement, then starting row = 12 total rows = 11 would return the next eleven and so on.

thanks

[drgroove]

Moved to the Oracle forum.

[pabloj]

You can either:
- Use a stored procedure
- Use rownum to limit the number of records returned

In the second case you should run a select count before the real query to retrieve the total number of rows returned.

[Dan Drillich]

Please try:

select table_name, n from (
select table_name, rownum n from (
select table_name from all_tables
order by table_name)
) where n >= 2 and n <= 4


Cheers,
Dan