Oracle syntax error [duplicate]

Oracle doesn't support the limit clause. That's a MySQL/Postgres thing.

There are alternatives, although they're often a lot more involved

The simplest equivalent is:

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

CodeHunter