SQL command not properly ended when using LIMIT
<p>I am executing the below query in SQL Developer.</p>

<pre><code>SELECT * FROM Person where person_name='rahul' order by created_time desc limit 10;
</code></pre>

<p>When I execute it, SQL Developer gives me below error.</p>

<pre><code>ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:
</code></pre>

<p>I used the below link for reference.</p>

<p><a href="https://www.techonthenet.com/sql/select_limit.php" rel="noreferrer">https://www.techonthenet.com/sql/select_limit.php</a></p>

<p>I already tried</p>

<pre><code>SELECT * FROM Person where person_name='rahul' order by created_time desc OFFSET 5 ROWS FETCH NEXT 10 ROWS ONLY;

ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:
Error at Line: 1 Column: 75
</code></pre>

<p>Note that OFFSET is not treated as keyword.</p>