Oracel8i LIMIT???

[Anon]

hello,
how can i limit an sql query in Oracle8i R3...

(like in mysql...)
SELECT * FROM test LIMIT 0,10

thanks,
oli

[Anon]

Try:
select * from test
where rownum < 10