oci8 for support oracle 12c AND issue of offset and limit order about laravel-oci8 HOT 5 CLOSED

protected function compileTableExpression($sql, $constraint, $query)
{
    // mohammadi Edited
    //if oracle 12c
    return $sql;

    //if old versions
    if ($query->limit > 0) {
        return "select t2.* from ( select rownum AS \"rn\", t1.* from ({$sql}) t1 ) t2 where t2.\"rn\" {$constraint}";
    } else {
        return "select * from ({$sql}) where rownum {$constraint}";
    }
}

//and the following func was left empty :)
protected function compileLimit(Builder $query, $limit)
{
    return "FETCH NEXT $limit ROWS ONLY";
}

/**
* Compile the "offset" portions of the query.
*
* @param  \Illuminate\Database\Query\Builder  $query
* @param  int  $offset
* @return string
*/
protected function compileOffset(Builder $query, $offset)
{
    return "OFFSET $offset ROWS";
}

////////////////////////////////////////////////////////////////////////////////
// in file :vendor\laravel\framework\src\Illuminate\Database\Query\Grammars
protected $selectComponents = array(
        'aggregate',
        'columns',
        'from',
        'joins',
        'wheres',
        'groups',
        'havings',
        'orders',
        'offset',
        'limit',
        'unions',
        'lock',
    );