The LIMIT clause isn't in Oracle but you can use the internal rownum index to grab the selected records. See Re: Querying Select Number of Rows for more info.