Query on Dql queries

Migrateduser

Can anyone guide how to use RETURN_PAGE option...I tried below but not works. I need to fetch 10 to 100 th row alone.

Select r_object_id, object_name from dm_folder where folder('') ENABLE( RETURN_PAGE 10 100 'r_object_id ASC');