Oracle 语法错误

Question

提问by murali

I got the following error in Oracle:

我在 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?

命令有什么问题？

Answer 1

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

Oracle 不支持该limit子句。那是 MySQL/Postgres 的事情。

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;