im_select_row_range

im_select_row_range   sql   firstrow   lastrow

a tcl proc curtisg wrote to return a sql query that will only contain rows firstrow - lastrow

Source code:

    return "select im_select_row_range_y.*
              from (select im_select_row_range_x.*, rownum fake_rownum 
                      from ($sql) im_select_row_range_x
                     where rownum <= $lastrow) im_select_row_range_y
             where fake_rownum >= $firstrow"