How to organize the correct LIMIT in Oracle?

Question

Oracle

I need to get the first 10 records. On the Internet for Oracle 11, they suggest doing this:

SELECT * FROM (
       select name from ...
       ) WHERE rownum < 10

those. via on request. I understand correctly that this is not effective. at the beginning, the whole subquery will be executed, and then it will be filtered? Or how are things?

Answer 1

select * from some_table
where rownum<=10

works fine too
what's the rationale for using a subquery?