Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: first N rows with a cursor

Re: first N rows with a cursor

From: Mervyn at ifwdc.com <merv_at_ifwdc.com>
Date: 2000/05/11
Message-ID: <8ff7pn$1lg3$1@brimstone.medianet.ie>#1/1

Jeff,

I don't know about the incompatibility, but you can easily achieve the same 10 rows in PL*SQL by declaring your cursor as the inner query only, and then loop 10 times around the fetch. That gives the same 10 rows.

Merv. Received on Thu May 11 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US