Limiting rows returned in SQL statement

What is the syntax (assuming there is a way) to limit the number of rows returned by a select statement in Oracle 7 or 8?

I know in Oracle (DEC)RDB there is a limit function -

Select * from TABLENAME limit to XX rows;

What is the syntax for Oracle SQL?

Thanks!

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 25 1999 - 11:48:10 CDT