unsigned int limit;
	bool        limit_set;
	int64       offset;
	bool        offset_set;

	SqlArray& SetLimit(unsigned int _limit)                { limit = _limit; limit_set = true; return *this; }
	SqlArray& SetOffset(int64 _offset)                     { offset = _offset; offset_set = true; return *this; }

	limit_set = false;
	offset_set = false;

		sql * ::Select(cols).From(table).Where(wh).OrderBy(orderby);

		SqlSet set = ::Select(cols).From(table).Where(wh).OrderBy(orderby);
		if(limit_set)
			if(offset_set) set.Limit(offset, limit);
			else set.Limit(limit);
		else
			if(offset_set) set.Offset(offset);
		sql * set;

	void      Limit(int _offset, int _count)               { offset = _offset; count = _count; }

sql * ::Select(cols).From(table).Where(wh).Limit(count).Offset(offset).OrderBy(orderby);

sql * ::Select(cols).From(table).Where(wh).OrderBy(orderby).Limit(count).Offset(offset);

select * from ( select a.*, ROWNUM as row_num from ( 
select .......... from .... where ...... order by ......
) a where rownum <= offset+limit) where row_num > offset

sql * ::Select(cols).From(table).Where(wh).OrderBy(orderby).Limit(count).Offset(offset);

in:

sql * ::Select(cols).From(table).Where(wh).OrderBy(orderby).Limit(offset,count);

SqlSelect& SqlSelect::Limit(int64 offset, int limit) {

    text = SqlCase(ORACLE,"select * from ( select rownum_a.*, ROWNUM as row_num from ( ")() + text +
           SqlCase(ORACLE,Format(") rownum_a where rownum <= %d ) where row_num > %d", offset+limit,offset))
                  (Format(" limit %d, %d",offset,limit));

	return *this;
}

 OCIStmtFetch2(stmthp, errhp, 1, OCI_FETCH_RELATIVE, fetchOffset, OCI_DEFAULT);

This fetches a row from the (scrollable) result set.