Siebel Paging System

Hi all,

Is there a way to achieve the below functionality in Siebel?

 

SELECT *
 FROM (SELECT ROWNUM rnum
             ,a.*
         FROM (SELECT *
                 FROM members) a)
WHERE rnum BETWEEN startrow# AND endrow#;

Is that possible to get data in a size of 1000 ? (when end-user scroll down,we want to fetch data 1000 by 1000)

Just want to double check this as there is a very large dataset (tens of millions) and apparently this is a way to avoid performance issues regarding this.

 

Thanks,

Cristian