does anyone know how to return multiple rowsets from an oracle stored procedure.
does anyone know how to limit the number of rows that are returned from a select query in oracle. I have a query that returns 100,000 rows. I only want to return the first 10 rows.
