Re: Cursor
From: Jeff Crew <jcrew_at_denadm.ms.ch2m.com>
Date: 1996/05/31
Message-ID: <4ont7m$6ke_at_ds9.ch2m.com>#1/1
Date: 1996/05/31
Message-ID: <4ont7m$6ke_at_ds9.ch2m.com>#1/1
In <31A4728E.2E05_at_chemoil.com>, AravindBR writes:
>In an explicitly declared cursor is it possible to move to the previous
>row ?
>>Steve Dodsworth responded:
>>Unless things have changed a great deal since I last checked, you cannot go
>>backwards through a cursor.
I agree with Steve ! Cursors will always go to the next
record. The only ways I
can think to get around this is to use a PL/SQL Table (2d
Array) or a temporary
table of the data that your cursor would select.
Regards
Jeff
Received on Fri May 31 1996 - 00:00:00 CEST