OraFAQ Forum: Server Administration » Re: current value vs. next value

Home » RDBMS Server » Server Administration » Re: current value vs. next value

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: current value vs. next value [message #370243]

Thu, 27 May 1999 08:44

Chris Hunt
Messages: 27
Registered: March 1999

Junior Member

There's no explicit current/next value properties for cursors, so you have to do it yourself something like...

DECLARE
   CURSOR c1 IS
      SELECT columnA,
             columnB
      FROM   table;
   prev_rec  c1%ROWTYPE;
BEGIN
   FOR my_rec IN c1 LOOP
      IF my_rec.columnB = prev_rec.columnB THEN
         Statement
      ELSE
         Statement 
      END IF;
      prev_rec := my_rec;
   END LOOP;
END;

Note that I compare each record with the previous one rather than the next, so you may need to read the table in reverse order.