Phalcon\Db\Dialect\Oracle::limit PHP Method

    public function limit($sqlQuery, $number)
    {
        $offset = 0;
        if (is_array($number)) {
            if (isset($number[1])) {
                $offset = intval(trim($number[1], $this->_escapeChar));
            }
            $limit = intval(trim($number[0], $this->_escapeChar)) + $offset;
        } else {
            $limit = intval(trim($number, $this->_escapeChar));
        }
        $sqlQuery = sprintf('SELECT * FROM (SELECT Z1.*, ROWNUM PHALCON_RN FROM (%s) Z1', $sqlQuery);
        if (0 != $limit) {
            $sqlQuery .= sprintf(' WHERE ROWNUM <= %d', $limit);
        }
        $sqlQuery .= ')';
        if (0 != $offset) {
            $sqlQuery .= sprintf(' WHERE PHALCON_RN >= %d', $offset);
        }
        return $sqlQuery;
    }