Oracle syntax error

Question

The following error appeared in Oracle:

SELECT * FROM abcd WHERE name LIKE 'a%' LIMIT 10 * ERROR at line 1: ORA-00933: SQL command not properly ended 

What is the problem with the team?

Answer 1

Oracle does not support the limit clause. This is the MySQL / Postgres thing.

There are alternatives, although they are often much more involved.

http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html

The simplest equivalent:

 select * from abcd where name like 'a%' and ROWNUM <= 10;