Oracle syntax error

Question

I got the following error 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 command?

skaffman · Answer 1 · 2010-03-01T16:42:35.533

15

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;

edited Mar 01 '10 at 16:42

answered Mar 01 '10 at 08:47

skaffman

then i want to limit the keywords to 10 for a specific search what should i do – Murali Krishna Pinjala Mar 01 '10 at 08:49
3

Please be careful when limiting query results using – Rene Mar 01 '10 at 10:57
1

@Rene: Indeed, it can bite you. In this case, though, it doesn't seem to matter. – skaffman Mar 01 '10 at 11:59
1

`LIMIT` is supported on MySQL and Postgres – OMG Ponies Mar 01 '10 at 15:44

1 Answers1