Fixes Arel's pagination issue for Oracle https://github.com/rails/arel/issues/438

oracle.rb

if o.limit && o.offset
  o           = o.dup
  limit       = o.limit.expr
  offset      = o.offset
  o.offset    = nil
  offset_bind = nil

  collector << "
      SELECT * FROM (
        SELECT raw_sql_.*, rownum raw_rnum_
        FROM ("

  collector = super(o, collector)

  collector << ') raw_sql_ WHERE rownum <= ('
  collector.add_bind(offset.expr) { |i| offset_bind = ":a#{i}" }
  collector << ' + '
  collector.add_bind(limit) { |i| ":a#{i}" }
  collector << ") ) WHERE raw_rnum_ > #{offset_bind}"

  return collector
end

Based on rootatdarkstar's solution