How to limit rows in oracle select queries

Question

I want to get the first 10 table Rows in USER database client table in oracle database 21c.how to write the query for it... I use, Select * from client LIMIT 10; it not worked.

I use, Select * from client LIMIT 10; for get first 10 table rows in client table, but it not worked(not give any output).

Answer 1

There is no LIMIT clause in Oracle SQL

Option 1:

select * from client fetch first 10 row only

Option 2:

select * from client where rownum <= 10