title: Entity Framework Core - Take(1), Single(), First()... Not Working with Oracle Provider (ORA-00933: SQL command not properly ended)
body: <p>I'm using ef core(2.2.4) with oracle database</p>
  
  <p>oracleProvider: Oracle.EntityFrameworkCore(2.18.0-beta3)</p>
  
  <p>this code:</p>
  
  <pre><code>IQueryable&lt;KeyInfo&gt; queryable = context
                  .KeyInfos
                  .Where(x =&gt; x.MobileNumber == "989191111111")
                  .Take(1);
  </code></pre>
  
  <p>generate this db query:</p>
  
  <pre><code>SELECT "x"."ID", "x"."Key", "x"."MobileNumber", "x"."NationalCode"
  FROM "KeyInfo" "x"
  WHERE "x"."MobileNumber" = N'989191111111'
  FETCH FIRST 1 ROWS ONLY;
  </code></pre>
  
  <p>running query give me this error:</p>
  
  <pre><code>ORA-00933: SQL command not properly ended
  00933. 00000 -  "SQL command not properly ended"
  *Cause:    
  *Action:
  Error at Line: 4 Column: 1
  </code></pre>
  
  <p>is any way to fix it? the correct way is to get the first row with </p>
  
  <blockquote>
    <p>AND rownum = 1</p>
  </blockquote>
  
  <p>not </p>
  
  <blockquote>
    <p>FETCH FIRST 1 ROWS ONLY</p>
  </blockquote>
  
  <p>and .ToList() works fine with IQueryable</p>